Use the chart builder to make 3 paneled pie charts showing the proportion that donated for each time of day

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Database Management Lab

DESCRIPTION

This is a hypothetical field study testing how variations of emails and other factors influence donations for a charity email campaign. Emails were randomly varied between two different subject lines and three different messages in the email body.

They were also sent to recipients of three different countries (USA, Canada, and the UK), at various times of day (local time for the recipient).

INSTRUCTIONS

• Download Lab_7_data.sav from Blackboard

• Follow the steps below

LAB QUESTIONS

1) We know from class that Subject Line A gets more opens than Subject Line B. But

does this effect exist across all three countries in the data?

a. Split file by Country_r.

b. Use Crosstabs with a Chi-Square Test with Opened_Email as rows and

SubjectLine as columns. Add column percentages in the cell options.

c. Take Split file off (Analyze all cases...)

2) Among those who opened the email, did recipients donate more often during a particular time of day?

a. Use Select Cases to include only cases where Opened_Email=1

b. Use Crosstabs with a Chi-Square Test with Donated as rows and TimeofDay as columns. Leave column percentages on, and add compare column proportions (z-test) with Bonferroni correction in the cell options.

c. Use the chart builder to make 3 paneled pie charts showing the proportion that donated for each time of day (panel variable = TimeofDay, statistic = percentage).

Export your Output to Excel and save it as Lab_7_YourName.xls.

In the Excel file, insert a brief answer (1-2 sentences) to the research questions above based on your interpretation of the results.

 Q1 Example: "Subject Line A significantly outperforms Subject Line B in

[country1] (p= ) and [country2] (p=), but not [country3] (p>0.05)."

 Q2 Example: "Yes, Time of Day had a significant affect on open rate, (p=), with post-hoc comparisons indicating that [timeofday_A] had a significantly higher open rate than both [timeofday_B] and [timeofday_C]."

 Your results may not fit this template exactly, but write it in that short and straightforward way.

When you are finished, submit the output file to Blackboard.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme