Description
Use the Mall Time Interview Results file, linked in the Resources under the Required Resources heading, to complete the calculations for this scenario.
Practical Application Scenario
As the food court manager at the Mall of Elbonia, you want to determine how much time customers spend at the mall at different times of the week (for example: midweek, day; midweek, evening; weekend, day; weekend, evening). Last week, the mall survey staff administered a random survey to mall visitors by selecting customers as they were leaving the mall. One of the questions asked was how much time the customer had spent in the mall on that day.
The findings from this study are provided in the Mall Time Interview Results file. In this file, Columns A through D show the time spent by the customers interviewed, according to the weekday and time of day when the interviews occurred.
Is there any statistically significant difference (at alpha = .05) in the average amount of time people spent in the mall, based on the weekday and time? To determine the answer to that question, you need to complete the following:
- Identify the null and alternative hypotheses you should form for this test. State each as a written explanation and as a math equation.
- Identify the appropriate statistical test you should use to accept or reject the null hypothesis.
- Calculate the appropriate ANOVA values to accept or reject your null and alternative hypotheses.
What should you tell the operators of the Mall of Elbonia’s food court stores (in terms of the mall’s high-traffic times and customer tendencies)? Summarize your statistical analysis in a report for management.
Additional Requirements
Compile your work and report in a 1–2 page Microsoft Word file:
- Paste in the tables you used to make your calculations.
- Clearly title your tables, including each row and column.
- Highlight the results of your data calculations within each table.
•
Use a provided data file to make a statistical inference to answer a hypothetical
question. Write a 1–2 page report to summarize your analysis.
Note: The assessments in this course build upon each other, so you are strongly
encouraged to complete them in sequence.
Managers must be able to apply statistical inference to business decisions. For
example, a manager might have to determine if there is a statistical significance in
the time of day and the habits of people while at the mall.
By successfully completing this assessment, you will demonstrate your proficiency
in the following course competencies and assessment criteria:
•
o
•
o
o
•
o
•
o
Competency 1: Evaluate the quality and fit of data for use in business analysis.
Determine the null hypothesis and alternative hypothesis for making decisions
regarding customer tendencies.
Competency 3: Analyze business decision opportunities using basic inferential
statistics.
Compute the ANOVA values to indicate acceptance or rejection of a null hypothesis
regarding customer tendencies.
Compute the appropriate statistical test to determine acceptance or rejection of a
null hypothesis.
Competency 5: Apply data analysis to general business management planning and
decision making.
Create a management report summarizing statistical analysis on customer shopping
tendencies.
Competency 6: Communicate in a manner that is professional and consistent with
expectations for members of the business professions.
Communicate in a manner that is professional and consistent with expectations for
members of the business professions.
Resources
Required Resources
The following resource contains the data needed to complete the assessment.
•
Mall Time Interview Results.
Suggested Resources
The resources provided here are optional. You may use other resources of your
choice to prepare for this assessment; However, you will need to ensure that they
are appropriate, credible, and valid. They provide helpful information about the
topics in this unit. The MBA-FP6018 – Data Analysis for Business Decisions Library
Guide can help direct your research. The Supplemental Resources and Research
Resources, both linked from the left navigation menu in your courseroom, provide
additional resources to help support you.
The following texts provide instruction in Statistics.
•
o
o
Bowerman, B., O’Connell, R., & Murphree, E. (2014). Business statistics in practice
(7th ed.). New York, NY: McGraw Hill. Available from the bookstore
Chapter 11, “Statistical Inferences for Population Variances,” in Business Statistics in
Practice, pages 412–424.
Chapter 12, “Experimental Design and Analysis of Variance,” in Business Statistics in
Practice, pages 426–453.
Additional Resources for Further Exploration
The following text provides instruction for statistical analysis in Microsoft Excel.
•
Salkind, N. J. (2016). Excel statistics: A quick guide (3rd ed.). Thousand Oaks, CA:
Sage. Available from the bookstore
The following text provides instruction for SAS one of the most commonly used
statistical analysis tools in business.
•
Slaughter, S. J., & Delwiche, L. D. (2010). The little SAS book for Enterprise Guide 4.2.
Cary, NC: SAS Institute. Available from the bookstore
The following resource is a tutorial that walks through a number of statistical
scenarios.
•
Statistical Technique Scenarios | Transcript.
Additional Statistics Tutorials
This website offers resources that cover many topics in statistics, including
presentations that illustrate how to use software to implement statistical methods.
•
•
•
•
StatisticsLectures.com (Producer). (n.d.). Introduction to ANOVA [Video]
| Transcript. Retrieved from http://www.statisticslectures.com/topics/introanova/
StatisticsLectures.com (Producer). (n.d.). One-way ANOVA [Video] | Transcript.
Retrieved from http://www.statisticslectures.com/topics/onewayanova/
StatisticsLectures.com (Producer). (n.d.). Independent and dependent
samples [Video] | Transcript.Retrieved from
http://www.statisticslectures.com/topics/independentdependentsamples/
Assessment Instructions
Use the Mall Time Interview Results file, linked in the Resources under the
Required Resources heading, to complete the calculations for this scenario.
Practical Application Scenario
As the food court manager at the Mall of Elbonia, you want to determine how much
time customers spend at the mall at different times of the week (for example:
midweek, day; midweek, evening; weekend, day; weekend, evening). Last week, the
mall survey staff administered a random survey to mall visitors by selecting
customers as they were leaving the mall. One of the questions asked was how much
time the customer had spent in the mall on that day.
The findings from this study are provided in the Mall Time Interview Results file.
In this file, Columns A through D show the time spent by the customers interviewed,
according to the weekday and time of day when the interviews occurred.
Is there any statistically significant difference (at alpha = .05) in the average amount
of time people spent in the mall, based on the weekday and time? To determine the
answer to that question, you need to complete the following:
•
•
•
Identify the null and alternative hypotheses you should form for this test. State each
as a written explanation and as a math equation.
Identify the appropriate statistical test you should use to accept or reject the null
hypothesis.
Calculate the appropriate ANOVA values to accept or reject your null and alternative
hypotheses.
What should you tell the operators of the Mall of Elbonia’s food court stores (in
terms of the mall’s high-traffic times and customer tendencies)? Summarize your
statistical analysis in a report for management.
Additional Requirements
Compile your work and report in a 1–2 page Microsoft Word file:
•
•
•
Paste in the tables you used to make your calculations.
Clearly title your tables, including each row and column.
Highlight the results of your data calculations within each table.
Mall Time Interview Results
Midweek, Day
66
78
66
32
35
34
88
149
86
145
146
38
95
80
106
42
95
77
98
71
122
125
85
97
33
End of worksheet
Midweek, Evening
64
71
174
53
52
96
135
142
149
59
82
118
132
81
111
68
22
50
125
105
92
115
148
66
74
Weekend, Day
64
121
29
147
162
108
61
77
88
131
127
141
176
161
3
82
128
51
81
54
161
158
45
134
38
Weekend, Evening
185
207
203
84
125
184
129
94
182
65
110
139
108
117
125
65
47
88
84
165
86
164
199
83
36
Purchase answer to see full
attachment
Use a provided data file to make a statistical inference to answer a hypothetical
question. Write a 1–2 page report to summarize your analysis.
Note: The assessments in this course build upon each other, so you are strongly
encouraged to complete them in sequence.
Managers must be able to apply statistical inference to business decisions. For
example, a manager might have to determine if there is a statistical significance in
the time of day and the habits of people while at the mall.
By successfully completing this assessment, you will demonstrate your proficiency
in the following course competencies and assessment criteria:
•
o
•
o
o
•
o
•
o
Competency 1: Evaluate the quality and fit of data for use in business analysis.
Determine the null hypothesis and alternative hypothesis for making decisions
regarding customer tendencies.
Competency 3: Analyze business decision opportunities using basic inferential
statistics.
Compute the ANOVA values to indicate acceptance or rejection of a null hypothesis
regarding customer tendencies.
Compute the appropriate statistical test to determine acceptance or rejection of a
null hypothesis.
Competency 5: Apply data analysis to general business management planning and
decision making.
Create a management report summarizing statistical analysis on customer shopping
tendencies.
Competency 6: Communicate in a manner that is professional and consistent with
expectations for members of the business professions.
Communicate in a manner that is professional and consistent with expectations for
members of the business professions.
Resources
Required Resources
The following resource contains the data needed to complete the assessment.
•
Mall Time Interview Results.
Suggested Resources
The resources provided here are optional. You may use other resources of your
choice to prepare for this assessment; However, you will need to ensure that they
are appropriate, credible, and valid. They provide helpful information about the
topics in this unit. The MBA-FP6018 – Data Analysis for Business Decisions Library
Guide can help direct your research. The Supplemental Resources and Research
Resources, both linked from the left navigation menu in your courseroom, provide
additional resources to help support you.
The following texts provide instruction in Statistics.
•
o
o
Bowerman, B., O’Connell, R., & Murphree, E. (2014). Business statistics in practice
(7th ed.). New York, NY: McGraw Hill. Available from the bookstore
Chapter 11, “Statistical Inferences for Population Variances,” in Business Statistics in
Practice, pages 412–424.
Chapter 12, “Experimental Design and Analysis of Variance,” in Business Statistics in
Practice, pages 426–453.
Additional Resources for Further Exploration
The following text provides instruction for statistical analysis in Microsoft Excel.
•
Salkind, N. J. (2016). Excel statistics: A quick guide (3rd ed.). Thousand Oaks, CA:
Sage. Available from the bookstore
The following text provides instruction for SAS one of the most commonly used
statistical analysis tools in business.
•
Slaughter, S. J., & Delwiche, L. D. (2010). The little SAS book for Enterprise Guide 4.2.
Cary, NC: SAS Institute. Available from the bookstore
The following resource is a tutorial that walks through a number of statistical
scenarios.
•
Statistical Technique Scenarios | Transcript.
Additional Statistics Tutorials
This website offers resources that cover many topics in statistics, including
presentations that illustrate how to use software to implement statistical methods.
•
•
•
•
StatisticsLectures.com (Producer). (n.d.). Introduction to ANOVA [Video]
| Transcript. Retrieved from http://www.statisticslectures.com/topics/introanova/
StatisticsLectures.com (Producer). (n.d.). One-way ANOVA [Video] | Transcript.
Retrieved from http://www.statisticslectures.com/topics/onewayanova/
StatisticsLectures.com (Producer). (n.d.). Independent and dependent
samples [Video] | Transcript.Retrieved from
http://www.statisticslectures.com/topics/independentdependentsamples/
Assessment Instructions
Use the Mall Time Interview Results file, linked in the Resources under the
Required Resources heading, to complete the calculations for this scenario.
Practical Application Scenario
As the food court manager at the Mall of Elbonia, you want to determine how much
time customers spend at the mall at different times of the week (for example:
midweek, day; midweek, evening; weekend, day; weekend, evening). Last week, the
mall survey staff administered a random survey to mall visitors by selecting
customers as they were leaving the mall. One of the questions asked was how much
time the customer had spent in the mall on that day.
The findings from this study are provided in the Mall Time Interview Results file.
In this file, Columns A through D show the time spent by the customers interviewed,
according to the weekday and time of day when the interviews occurred.
Is there any statistically significant difference (at alpha = .05) in the average amount
of time people spent in the mall, based on the weekday and time? To determine the
answer to that question, you need to complete the following:
•
•
•
Identify the null and alternative hypotheses you should form for this test. State each
as a written explanation and as a math equation.
Identify the appropriate statistical test you should use to accept or reject the null
hypothesis.
Calculate the appropriate ANOVA values to accept or reject your null and alternative
hypotheses.
What should you tell the operators of the Mall of Elbonia’s food court stores (in
terms of the mall’s high-traffic times and customer tendencies)? Summarize your
statistical analysis in a report for management.
Additional Requirements
Compile your work and report in a 1–2 page Microsoft Word file:
•
•
•
Paste in the tables you used to make your calculations.
Clearly title your tables, including each row and column.
Highlight the results of your data calculations within each table.
Mall Time Interview Results
Midweek, Day
66
78
66
32
35
34
88
149
86
145
146
38
95
80
106
42
95
77
98
71
122
125
85
97
33
End of worksheet
Midweek, Evening
64
71
174
53
52
96
135
142
149
59
82
118
132
81
111
68
22
50
125
105
92
115
148
66
74
Weekend, Day
64
121
29
147
162
108
61
77
88
131
127
141
176
161
3
82
128
51
81
54
161
158
45
134
38
Weekend, Evening
185
207
203
84
125
184
129
94
182
65
110
139
108
117
125
65
47
88
84
165
86
164
199
83
36
Purchase answer to see full
attachment
Categories: