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
Variables = Recoded Broadband Access?
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.
Answer questions 4-6.
Once you have completed each question, please submit one Microsoft Word document including all of your responses and supporting tables and charts. The attached grading rubric will be used to grade your assignment.
