# Complete the Chapter 6 Case 1 Problem: Young Professional Magazine in the Essentials of Business Analytics (2nd ed.) textbook.

I don’t understand this Excel question and need help to study.

A Managerial Report should be created summarizing your responses to all six questions at the end of the case problem. The following Minitab instructions can be used to create the statistical summaries in support of your responses. Please provide an interpretation for each table and graph.

Question 1

Descriptive Statistics:
Minitab: Stat – Basic Statistics – Display Descriptive Statistics
Place the Age, Value of Investments, Number of Transactions, and Household Income variables in the Variables box.
Then select the “Statistics” icon.
Check the N total, Mean, SE of Mean, Standard Deviation, Minimum, Maximum, and Skewness variables.
Then select the “ok” icon, Then select the “ok” icon again to run the analysis.

Question 2

95% Confidence Intervals
Minitab: Stat – Basic Statistics – Graphical Summary
Variables = Age
Confidence level = 95.0
Select the “ok” icon to generate the chart.

95% Confidence Intervals
Minitab: Stat – Basic Statistics – Graphical Summary
Variables = Household Income
Confidence level = 95.0
Select the “ok” icon to generate the chart.

Question 3

Minitab: Data – Recode – To Numeric
Recode values in the following columns: Broadband Access?
Method: Recode individual values

 Current value Recoded value No 0 Yes 1

Storage location for the recoded columns: At the end of the current worksheet
Check: Show summary table
Select “ok” to recode the data

95% Confidence Intervals
Minitab: Stat – Basic Statistics – Graphical Summary
Confidence level = 95.0
Select the “ok” icon to generate the chart.

Minitab: Data – Recode – To Numeric
Recode values in the following columns: Have Children?
Method: Recode individual values

 Current value Recoded value No 0 Yes 1

Storage location for the recoded columns: At the end of the current worksheet
Check: Show summary table
Select “ok” to recode the data

95% Confidence Intervals
Minitab: Stat – Basic Statistics – Graphical Summary
Variables = Recoded Have Children?
Confidence level = 95.0
Select the “ok” icon to generate the chart.