.Construct a contingency table that shows frequencies for the qualitative variables Gender (Male or Female) and Use of Social Networking Sites

Analytics For Decision-Making
10/09/2019
Expansion Strategy
10/09/2019

.Construct a contingency table that shows frequencies for the qualitative variables Gender (Male or Female) and Use of Social Networking Sites

Cases are assigned from the end of chapters that represent real world applications of the statistical concepts

discussed in the chapter. You will use Microsoft Excel to perform the statistical procedures. You will also use

Microsoft Word to prepare a managerial report that summarizes the key requirements of the case, explains the

statistical methods used, discusses the results, and recommends a course of action based on your analysis. The

managerial report will be submitted to Safe Assign for originality.

Deliverables

 Managerial report o Use format available in Sample Managerial Report;

 Section 1 summarizes the case described in the chapter. Include in this section any descriptive statistics and state the purpose and objective of the case. DO NOT copy the

case.

 Section 2 should describe the statistical methods used to analyze the case. Include interval estimates, hypothesis tests, tables and charts as necessary. DO NOT include the

data set in the report. Figures and tables should be labeled (Table 1. Descriptive statistics,

Figure 1. Chi-square distribution, etc.) and properly formatted for clarity.

 Section 3 should provide the conclusions of your analysis and recommendations for future action. Include your answers to any questions posed in this section.

 Excel Spreadsheet o Use separate sheet for each chart, pivot table, and table created with the Analysis Tool-Pak. o Name each tab with the name of the table or chart. o Format numbers to 3 decimal places.

Grading

A rubric in Blackboard is used to grade each case study:

 Spreadsheet – Demonstrate ability to use Microsoft Excel to perform statistical analysis. o Use of analysis tools, pivot tables, charts, graphs, formulas and functions.

 Managerial Report – Demonstrate understanding of statistical methods. o Provide a clear and focused summary of the case along with stated purpose and objectives; o Critically analyze data and explain statistical procedures used along with resultant outcomes; o Make logical recommendations to management supported by statistical analysis; o Use proper punctuation, spelling and grammar. Tables and charts should be properly identified,

formatted, and referenced in the document.

Data File: NO DATA FILE NEEDED (More information found p. 158-159 in 3rd edition of

the textbook.)

1. Construct a contingency table that shows frequencies for the qualitative variables Gender (Male or

Female) and Use of Social Networking Sites (Yes or No).

2. Determine the probability that a teen uses social networking sites. 3. Determine the probability that a teen girl uses a social networking site. 4. A bill before Congress would like to extend the Children’s Online Privacy Protection Act to apply to

15-year-olds. In addition, the bill would also ban Internet companies from sending targeted

advertising to children under 16 and give these children and their parents the ability to delete their

digital footprint and profile with an “eraser button” (The Boston Globe, May 20, 2012). Given the

probabilities that you calculated with respect to teen usage of social networking sites, do you thing

that this legislation is necessary? Explain.

WhatsApp Chat with us on Whatsapp