QNT 5160 Nova Southeastern University Business Report Worksheet

Business Report Template
Prepared by:
Date:
Nova Southeastern University
H. Wayne Huizenga School
of Business & Entrepreneurship
Assignment for Course:
Submitted to:
Submitted by:
Date of Submission:
Title of Assignment:
CERTIFICATION OF AUTHORSHIP: I certify that I am the author of this paper and that any assistance I received in
its preparation is fully acknowledged and disclosed in the paper. I have also cited any sources from which I used
data, ideas or words, either quoted directly or paraphrased. I also certify that this paper was prepared by me
specifically for this course.
Student’s Signature: _______CR_______________________
*****************************************************************
Instructor’s Grade on Assignment:
Instructor’s Comments:
Management Report
Executive Summary
Background
Problem
Methods
Results
[Present descriptive statistics first followed by inferential statistics and then the interpretation.]
Conclusions and Recommendations
References
Appendix
Tables and Figures
Territory No. of Stores No. of Dealers
No.
(in hundred) (in hundred)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
8
6
23
24
6
6
9
18
15
16
13
16
17
12
7
10
2
3
9
7
8
16
15
14
18
5
11
10
13
15
7
6
57
61
12
3
17
45
28
29
29
20
69
8
14
20
2
18
9
4
19
21
48
26
52
5
19
27
72
55
No. of
Popular
Brands
Population
(in thousand)
Sales (in $mil)
12
13
12
14
13
11
13
2
9
9
3
4
3
16
13
11
14
14
14
14
13
16
9
13
6
12
12
8
4
5
71
73
135
122
70
45
62
128
103
115
125
139
156
68
73
85
56
68
67
62
70
100
143
102
153
58
96
114
140
134
42
20
68
18
20
25
8
29
35
41
45
68
33
9
29
14
17
2
0.5
2
33
26
45
13
73
3
23
50
46
64
Stores_ Brands_
binary binary
low
high
Dependent,Indepenent Variables
Pearson’s
Correlation
Coefficient r
Sales & Population
Sales & No. Stores
Sales & No. Pop Brands
Sales & No. Dealers
First, calculate the descriptive statistics (mean
and standard deviation) of each variable.
Next, determine the correlation coefficients
between sales and each potential correlated
variable in the data set.
Interpret what these correlations mean. Include
the magnitude and direction of each
relationship.
Is territory number an appropriate variable for a
correlation? Why or why not?
Relationship
(strength + direction)
Count of Brands_binary Column Labels
Row Labels
0
1
Grand Total
0 1 Grand Total
3 12
15
10 5
15
13 17
30
Individual Case Study Instructions
Instructions
Conduct necessary calculations and visualizations to answer the questions.
You must submit your Excel spreadsheet model(s) with calculations/formulas (no hard coded numbers)
and visualizations along with a properly formatted business report to receive full credit.
Reports and models should be uploaded to the Canvas dropbox before the posted deadline. You may
submit additional Excel spreadsheets if you feel they are necessary to support your answers.
Prepare a report, which includes your answers to the assignment questions. See the Grading Policy
section of the Getting Started module for an example. Your report should follow APA formatting.
Grading
A total of 9 points is possible for this assignment. This includes the point values which are assigned to
each question (point values are noted next to each question below) plus 1 point which are earned based
on following the prescribed assignment format, and the proper writing style and APA format.
Background
Magic Foods is a leading manufacturer of pickles, spice pastes, instant mixes. With quality products and
customer satisfaction, Magic foods maintains a leading position in the processed food section y
widening its customer base. However, very recently the company witnessed an increase in competition
resulting in a decrease in its sales. To analyze the factors driving the sales, company collected data
across 30 territories on five important factors which were determined by company leadership to be
crucial in determining the sales: market potential in the territory, number of shops selling processed
foods, number of dealers in each territory, number of brands and population of each territory.
1
Part 1 (1 point):
Question: Define a problem statement which reflects the challenge facing Magic Foods leadership.
Part 2 (3 points):
Apply descriptive modeling to analyze relationships between company sales and the four predictor
variables. Interpret the meaning of each relationship and how it relates to the Magic Foods company.
Illustrate your answer with appropriate statistics and visualizations.
Part 3 (3 points):
Construct a pivot table showing the relationship between the number of store and either the number of
brands or number of dealers. Hint: You will need to convert these quantitative variables to qualitative
variables. Discuss the results and implications of your analysis.
Part 4 (1 points):
Interpret and discuss the results of your analysis including the implications for future data analysis.
Provide recommendations for the Magic Foods management.
2

Purchase answer to see full
attachment