+1 (208) 254-6996 essayswallet@gmail.com
  

 DUE IN 36 HOURS: 

In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel®. Answer the questions about the information in your Excel sheet in a separate Word document:
·  Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.” – See reference material below.
·  Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.
·  Create a box-plot for the “Annual Sales” variable.
·  Create a histogram for the “Sales/SqFt” variable.

In a separate APA style Word document Answer the following questions based on the results of your analysis in Excel®. As an APA style document remember to have an introduction, the body, and a conclusion. Those should all be based on this analysis from the Pastas R Us, Inc. Database.
·  Based box-plot for the “Annual Sales” variable; does the boxplot look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?
·  Based on the histogram for the “Sales/SqFt” variable; is the distribution symmetric? If not, what is the skew? Are there any outliers? If so, which one(s)? What is the “SqFt” area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation?
·  What measure of central tendency is more appropriate to describe “Sales/SqFt”? Why?

Reference Material:
Scenario: 
Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. Since its inception, the business development team has favored opening new restaurants in areas (within a 3-mile radius) that satisfy the following demographic conditions:
·  Median age between 25 – 45 years old
·  Household median income above national average
·  At least 15% college educated adult population

Last year, the marketing department rolled out a Loyalty Card strategy to increase sales. Under this program, customers present their Loyalty Card when paying for their orders and receive some free food after making 10 purchases.

The company has collected data from its 74 restaurants to track important variables such as average sales per customer, year-on-year sales growth, sales per sq. ft., Loyalty Card usage as a percentage of sales, and others. A key metric of financial performance in the restaurant industry is annual sales per sq. ft. For example, if a 1200 sq. ft. restaurant recorded $2 million in sales last year, then it sold $1,667 per sq. ft. 

ChartDataSheet_

This worksheet contains values required for MegaStat charts.
Residuals X data 3/19/2007 7:49.25
66184517734.431
69165188841.220
67105137940.324
7046608135.429
7805099931.518
62284156236.330
70284419635.114
84295097537.633
68227280834.928
60427907034.829
80367849736.239
64324124532.223
80223300330.922
88789098837.737
42353795034.324
68324520632.417
80487931232.137
84323734531.422
35274622630.436
84247002433.934
78165498235.626
80395493235.920
70703409733.620
76334659337.926
56125189340.621
65328816237.737
6208901636.434
662011435340.934
7624753663530
92364816326.416
112344995637.128
66154599030.336
70284572331.318
60154380029.636
86106871132.918
7606515040.724
68163932929.322
6406365737.329
52366709939.825
78267515133.928
6428938763540
8232797013539
86307711535.930
9216527663317
72103292930.922
90248786338.529
64207375240.519
80208536632.129
102303918034.818
7026560773819
6226774493734
68205682234.725
74248047036.430
84145558436.821
70327800132.230
96327530734.830
70227637536.728
76326185733.831
62286131234.216
9223720403931
60209241434.940
54159260239.333
110235959935.628
780724533623
72316792541.116
74294263124.725
9407565240.525
80163965032.918
12404803330.315
46206740336.219
6608059732.427
63286092843.521
72157376241.629
76246422531.415
NormalPlot data 3/19/2007 7:49.03
-259.9497306439-2.3669115357
-188.5900144767-2.0061237235
-178.1863109741-1.8007082352
-165.2888689211-1.6514108613
-156.2930386781-1.5318456091
-147.1995334043-1.4308738679
-145.0204151759-1.3426905457
-132.7962270775-1.2638662791
-132.5838765031-1.1921973902
-127.8657575015-1.1261791757
-124.4916500844-1.0647357757
-123.016384493-1.0070695657
-118.431306853-0.952571595
-110.8440652315-0.9007655189
-110.1477551652-0.8512709934
-109.3430277914-0.8037789242
-105.1097263145-0.7580342264
-104.7616892077-0.7138235056
-100.1917272772-0.6709660579
-96.9455399284-0.6293071641
-78.5222407532-0.588713006
-66.833182556-0.5490667518
-63.9367962151-0.5102654979
-54.9666697606-0.4722178495
-49.5089341383-0.4348419815
-43.817663257-0.3980640685
-30.5622414309-0.3618169976
-29.7056802184-0.3260393031
-28.8211160258-0.2906742745
-21.3829190469-0.2556692022
-20.8096302471-0.220974732
-18.0336858908-0.1865443062
-16.4732294274-0.152333674
-15.5268611118-0.1183004556
-12.5832024808-0.0844037498
-11.5991899485-0.0506037738
-10.6416197419-0.0168615273
-6.46632887350.0168615273
6.60820907260.0506037738
10.10263890270.0844037498
10.15566915820.1183004556
11.54243241030.152333674
13.47925572330.1865443062
15.02139668430.220974732
18.96637981160.2556692022
19.21220252790.2906742745
19.59382877380.3260393031
19.74198443040.3618169976
23.74707813540.3980640685
25.17362173870.4348419815
28.91943868720.4722178495
38.46975645040.5102654979
50.98317884170.5490667518
53.03570682830.588713006
61.1029039060.6293071641
63.12049535480.6709660579
63.83801537180.7138235056
71.08335397280.7580342264
71.32816483750.8037789242
75.18288589290.8512709934
75.28025254690.9007655189
81.32065543570.952571595
81.63510255361.0070695657
105.5764644421.0647357757
115.02538442931.1261791757
122.22338041681.1921973902
150.11784901061.2638662791
180.39342851671.3426905457
196.26713758451.4308738679
205.79931400081.5318456091
234.85633376171.6514108613
289.73389309921.8007082352
336.09044955562.0061237235
372.51959396072.3669115357
Residuals X data 3/19/2007 8:01.41
66184517734.431
69165188841.220
67105137940.324
7046608135.429
7805099931.518
62284156236.330
70284419635.114
84295097537.633
68227280834.928
60427907034.829
80367849736.239
64324124532.223
80223300330.922
88789098837.737
42353795034.324
68324520632.417
80487931232.137
84323734531.422
35274622630.436
84247002433.934
78165498235.626
80395493235.920
70703409733.620
76334659337.926
56125189340.621
65328816237.737
6208901636.434
662011435340.934
7624753663530
92364816326.416
112344995637.128
66154599030.336
70284572331.318
60154380029.636
86106871132.918
7606515040.724
68163932929.322
6406365737.329
52366709939.825
78267515133.928
6428938763540
8232797013539
86307711535.930
9216527663317
72103292930.922
90248786338.529
64207375240.519
80208536632.129
102303918034.818
7026560773819
6226774493734
68205682234.725
74248047036.430
84145558436.821
70327800132.230
96327530734.830
70227637536.728
76326185733.831
62286131234.216
9223720403931
60209241434.940
54159260239.333
110235959935.628
780724533623
72316792541.116
74294263124.725
9407565240.525
80163965032.918
12404803330.315
46206740336.219
6608059732.427
63286092843.521
72157376241.629
76246422531.415
NormalPlot data 3/19/2007 8:01.03
-259.9497306439-2.3669115357
-188.5900144767-2.0061237235
-178.1863109741-1.8007082352
-165.2888689211-1.6514108613
-156.2930386781-1.5318456091
-147.1995334043-1.4308738679
-145.0204151759-1.3426905457
-132.7962270775-1.2638662791
-132.5838765031-1.1921973902
-127.8657575015-1.1261791757
-124.4916500844-1.0647357757
-123.016384493-1.0070695657
-118.431306853-0.952571595
-110.8440652315-0.9007655189
-110.1477551652-0.8512709934
-109.3430277914-0.8037789242
-105.1097263145-0.7580342264
-104.7616892077-0.7138235056
-100.1917272772-0.6709660579
-96.9455399284-0.6293071641
-78.5222407532-0.588713006
-66.833182556-0.5490667518
-63.9367962151-0.5102654979
-54.9666697606-0.4722178495
-49.5089341383-0.4348419815
-43.817663257-0.3980640685
-30.5622414309-0.3618169976
-29.7056802184-0.3260393031
-28.8211160258-0.2906742745
-21.3829190469-0.2556692022
-20.8096302471-0.220974732
-18.0336858908-0.1865443062
-16.4732294274-0.152333674
-15.5268611118-0.1183004556
-12.5832024808-0.0844037498
-11.5991899485-0.0506037738
-10.6416197419-0.0168615273
-6.46632887350.0168615273
6.60820907260.0506037738
10.10263890270.0844037498
10.15566915820.1183004556
11.54243241030.152333674
13.47925572330.1865443062
15.02139668430.220974732
18.96637981160.2556692022
19.21220252790.2906742745
19.59382877380.3260393031
19.74198443040.3618169976
23.74707813540.3980640685
25.17362173870.4348419815
28.91943868720.4722178495
38.46975645040.5102654979
50.98317884170.5490667518
53.03570682830.588713006
61.1029039060.6293071641
63.12049535480.6709660579
63.83801537180.7138235056
71.08335397280.7580342264
71.32816483750.8037789242
75.18288589290.8512709934
75.28025254690.9007655189
81.32065543570.952571595
81.63510255361.0070695657
105.5764644421.0647357757
115.02538442931.1261791757
122.22338041681.1921973902
150.11784901061.2638662791
180.39342851671.3426905457
196.26713758451.4308738679
205.79931400081.5318456091
234.85633376171.6514108613
289.73389309921.8007082352
336.09044955562.0061237235
372.51959396072.3669115357

Data

Pastas R Us, Inc. Database (n = 74 restaurants)
Square FeetPer Person Average SpendingSales Growth Over Previous Year (%)Loyalty Card % of Net SalesAnnual Sales Per Sq FtMedian HH Income (3 Miles)Median Age (3 Miles)% w/ Bachelor’s Degree (3 Miles)
ObsSqFtSales/PersonSalesGrowth%LoyaltyCard%Sales/SqFtMedIncomeMedAgeBachDeg%
123546.81-8.312.07701.974517734.431
226047.57-4.012.54209.935188841.220
324536.89-3.941.66364.925137940.324
423407.13-3.392.06443.046608135.429
525007.04-3.302.48399.205099931.518
628066.93-1.942.96264.644156236.330
722507.11-0.772.28571.594419635.114
824007.13-0.372.34642.255097537.633
927096.58-0.252.20461.457280834.928
1019906.77-0.172.34638.827907034.829
1123926.660.472.09484.387849736.239
1224087.030.552.47581.094124532.223
1326277.030.772.04267.713300330.922
1425007.001.922.02572.849098837.737
1519867.382.052.01586.483795034.324
1625007.182.122.64368.734520632.417
1726687.352.842.22351.477931232.137
1825176.952.882.07458.243734531.422
1912517.023.961.94987.124622630.436
2029986.854.042.17357.457002433.934
2126257.164.050.72405.775498235.626
2223006.994.052.00680.805493235.920
2327617.284.241.81368.023409733.620
2427647.074.582.13303.954659337.926
2524307.055.092.50393.905189340.621
2621546.545.142.63562.128816237.737
2724006.705.481.95494.888901636.434
2824306.915.862.04310.0711435340.934
2925497.585.911.41373.467536635.030
3025007.035.982.05235.814816326.416
3136536.846.082.13413.084995637.128
3224406.946.082.08625.224599030.336
3326007.076.132.73274.304572331.318
3421607.006.271.95542.624380029.636
3528007.086.572.04178.566871132.918
3627576.756.901.62375.336515040.724
3724506.816.941.95329.093932929.322
3824007.647.121.64297.376365737.329
3922706.627.391.78323.176709939.825
4028006.767.672.23468.847515133.928
4125207.117.912.15352.579387635.040
4224877.058.082.83380.347970135.039
4326296.908.272.37398.127711535.930
4432007.178.543.07312.155276633.017
4523356.758.582.19452.163292930.922
4625007.458.721.28698.648786338.529
4724497.008.751.76367.197375240.519
4826256.968.792.51431.938536632.129
4931507.308.901.90367.063918034.818
5026256.969.121.98400.535607738.019
5127416.719.472.41414.367744937.034
5225006.8210.172.17481.115682234.725
5324506.5810.662.16538.068047036.430
5429867.5610.970.29330.485558436.821
5529676.9811.341.85249.937800132.230
5630007.2811.451.88291.877530734.830
5725006.7611.512.19517.407637536.728
5826006.9211.732.56551.586185733.831
5928006.7311.832.16386.816131234.216
6029866.9111.952.10427.507204039.031
6122236.7712.471.98453.949241434.940
6223007.3312.800.87512.469260239.333
6337997.8713.781.07345.275959935.628
6427006.9514.093.38234.047245336.023
6526507.3314.231.17348.336792541.116
6625006.9514.602.14348.474263124.725
6729947.2114.880.93294.957565240.525
6827187.2515.422.22361.143965032.918
6937007.6516.181.68467.714803330.315
7020006.9317.232.41403.786740336.219
7124006.7918.432.81245.748059732.427
7224507.3720.761.09339.946092843.521
7325756.7625.540.64400.827376241.629
7424007.9728.811.77326.546422531.415

Noodles Database – Page &P of &N Printed &D Doane/Seward