Resources: Pastas R Us. Inc. Database at Microsoft Exce|. Wk I: Descriptive Statistics Analysis Assignment This assignment is intended to help leam how to apply statistical methods when analyzing operational data, evaluating the performance of current marketing strategies. and recommending actionable business decisions. This is an opportunity to build critical-thinking and problem-solving skills within the context of data analysis and interpretation. You'll gain a first-hand understanding of how data analytics supports decision-making and adds value to an organization. Scenario: Pastas Ft 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 im 74 restaurants to lrack important variables such as averme sales per cuslomer. year-on-year sales growth, sales per sq. ft. Loyalty Card usage as a percentage of sales, and others. A key metric of nancial performance in the restaurant industry is annual sales per sq. ft. For example, if a 1200 so. it. restaurant recorded $2 million in sales last year. then it sold $1,667 per sq. ft. Executive management wants to know whether the current expansion criteria can be improved. They want to evaluate the effectiveness of the Loyalty Card marketing strategy and identify feasible, actionable opportunities for improvement. As a member of the analytics department. you've been assigned the responsibility of conducting a thorough statistical analysis of the company's available database to answer executive management's questions. 750-word statistical report that includes the following sections: - Section 1: Scope and descriptive statistics . Section 2: Analysis . Section 3: Recommendations and Implementation Section I - Scope and descriptive statistics - State the report's objective. - Discuss the nature of the current database. What variables were analyzed? Executive management wants to know whether the current expansion criteria can be improved. They want to evaluate the effectiveness of the Loyalty Card marketing strategy and identify feasible, actionable opportunities for improvement. As a member of the analytics department. you've been assigned the responsibility of conducting a thorough statistical analysis of the company's available database to answer executive management's questions, 750-word statistical report that includes the following sections: - Section 1: Scope and descriptive statistics - Section 2: Analysis . Section 3: Recommendations and Implementation Section I - Scope and descriptive statistics . State the report's objective. - Discuss the nature of the current database. What variables were analyzed? - Summarize your descriptive statistics ndings from Excel. Use a table and insert appropriate graphs. Section 2 - Analysis - Using Excel. create scatter plots and display the regression equations for the following pairs of variables: . "BachDeg%' Versus "Sales/SqFt" - "Medlncome" versus "Sales/SqFt" - "MedAge" versus 'Sales/SqFt" - "LoyaltyCardl%)" versus 'SalesGrowth(%)" In your report, include the scatter plots. For each scatter plot. designate the type of relationship observed (increasing/positive. decreasingegative, or no relationshipi and determine what you can conclude from these relationships. Section 3: Recommendations and implementation - Based on your findings above. assess which expansion criteria seem to be more effectiveCould any expansion criterion be changed or eliminated? If so. which one and why? . Based on your findings above. does it appear as if the Loyalty Card is positively correlated with sales growth? Would you recommend changing this marketing strategy? . Based on your previous ndings, recommend marketing positioning that targets a specific demographic. (Hint: Are younger people patronizing the restaurants more than older people?) - Indicate what information should be collected to track and evaluate the effectiveness of your recommendations. How can this data be collected? (Hint Would you use survey/samples or census?) ... AutoSave O OFF A A C ... PastasRUs Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ... & Cut Arial 10 AA 27 V ap Wrap Text v General 2 AutoSum ~ Av hi- [A Copy Fill Paste Merge & Center v Format Cell Format IUVV LAV $ ~ % " Insert Delete Format Sort & Find & nalyze Formatting as Table Styles Clear v Filter Select Data R48 4 X V fx G H K M N O Q R S W X Pastas R Us, Inc. Database (n = 74 restaurants) N- Per Person Sales Growth Over| Loyalty Card % of Annual Sales Median HH Income | Median Age | % w/ Bachelor's Annual Square Feet Average Spending Previous Year (%) Net Sales Per Sq Ft (3 Miles) (3 Miles) Degree (3 Miles) Sdales Obs SqFt Sales/Person Sales Growth% Loyalty Card% Sales/SqFt Medincome MedAge BachDeg%% 2354 6.81 -8.31 2.07 701.97 45177 34.4 31 1652477.4 2604 7 .57 4.01 2.54 209.93 -3.94 1.66 51888 41.2 20 546657.7 2453 6.89 364.92 51379 40.3 895148.8 2340 7.13 -3 39 2.06 443.04 66081 35.4 1036714 2500 7.04 -3.30 2.48 399 .20 10999 31.5 2806 6.93 -1.94 2.96 264 .64 41562 36 .3 742579.8 2250 7.11 -0.77 2.28 571.59 44196 35.1 1286078 7.13 -0.37 2.34 642.25 50975 37.6 1541400 2709 6.58 -0.25 2.20 72808 34.9 1250068 6.77 -0.17 2.34 638 . 82 79070 34 .8 1271252 2392 6.66 0.47 2.09 78497 36.2 1 158637 2408 7.03 0.55 581.09 4145 32.2 1399265 2627 7.03 2.04 33003 703274.2 7.00 1.92 267.71 30.9 2500 572.84 90988 37.7 1432100 1986 7.38 2.05 2.01 586 .48 3795 34.3 1164749 2 .12 2.64 368.73 45206 32.4 7:35 921825 2668 2.84 2.22 351.47 79312 32 .1 937722 2517 6.95 2.8 8 2.07 458.24 37345 31.4 1153390 1251 7.02 3.96 1.94 987 .12 46226 30.4 4.04 1234887 2998 6.85 33.9 2625 4.05 0.72 70024 1071635 405.77 54982 35.6 1065146 6.99 4.05 2.00 680 . 80 54932 35.9 1565840 34097 33.6 1016103 7.07 4 .24 4 .58 1.81 368 . 02 2.13 303 .95 46593 37.9 340117.8 6.54 5.09 2.50 51893 40.6 95717 5 .14 93.90 88162 37.7 1210806 6.70 5.48 1.95 494.88 9016 36.4 1187712 5 .86 2.04 310.07 14353 40.9 753470. 7.58 5.91 1.41 373.46 75366 35.0 951949 .5 10 points 7.03 5.98 2.05 235 . 81 48163 26.4 589525 6 .08 413.08 49956 37 .1 1508981 6 .08 2.08 45990 30 .3 152553 2600 7.07 2.73 274 .30 45723 31.3 713180 2160 7.00 6 .13 7.08 6.27 1.95 542 . 62 43800 29.6 1172059 2800 6.57 2.04 68711 32.9 499968 2757 6.90 1.62 375.33 5150 40.7 1034785 2450 6.81 1.95 2400 7.64 6.94 329.09 39329 7.12 806270.5 1.64 63657 37.3 713688 2270 6.62 7.39 1.78 323 .17 67099 39.8 733595.9 2800 6.76 7.67 2.23 468.84 75151 33.9 1312752 2520 7.11 7.91 2.15 93876 35.0 888476.4 2487 7.05 8.08 2.83 380.34 35.0 945905.6 2629 6.90 2.37 39 77115 35.9 104665 3200 7.17 8.27 398 .12 33.0 17 99888 2335 6.75 8.58 3.07 312 . 15 52766 2.19 452.16 32929 30.9 22 1055794 Data Sheet1 Ready 12 Accessibility: Good to go 8 0 9 - - + 100% Report: Write a 750-word statistical report that includes the following sections: Section 1: Scope and descriptive statistics Section 2: Analysis Save and Close Submit X P W & ? S itv Macintosh HD... AutoSave O OFF A A C ... PastasRUs Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ... & Cut Arial 10 A A 27 V de Wrap Text v General 2 AutoSum ~ Av hi- [ Copy Fill Paste Cell Sort & Format IUVV LAV Merge & Center v $ ~ % " Format Insert Delete Format Find & nalyze Formatting as Table Styles Clear v Filter Select Data R48 + X V fx C F G H K M N O Q R S W X 48 2629 6.90 2.37 8.54 3.07 398.12 7115 35.9 30 104665 50 3200 7.17 312.15 52766 33.0 17 998 880 2335 6.75 8 .58 2.19 32929 7.45 698. 64 30.9 1055794 2500 87863 52 8.72 1.28 38.5 1746600 2449 7.00 8.75 1.76 40.5 53 54 2625 6.96 2.51 367 . 19 73752 899248.3 7.30 8.79 536 3150 1.90 367.06 32.1 1133816 9180 1156239 55 2625 6.96 9.12 1.98 400.53 56077 38.0 56 1051391 2741 6.71 9.47 2.41 414.36 7449 37.0 1135761 2500 6.82 10.17 2 .17 481.11 6822 34.7 120277 2450 6.58 10.66 0470 7.56 2.16 36.4 1318247 2986 6.98 10.97 0.29 330 .48 5584 36 .8 986813.3 2967 11.34 1.85 249.93 78001 30 741542.3 3000 11.45 1.8 8 2500 7.28 291.87 34.8 875610 6.76 11.51 6.92 2. 19 17.40 76375 36.7 129350 11.73 2 .56 551.58 1434108 2800 61857 33.8 6.73 11.83 2.16 386 . 81 61312 34.2 1083068 6.91 11.95 2.10 427.50 72040 39.0 31 1276515 6.77 12.47 1.98 453.94 92414 34.9 1009109 7.33 12.80 0.87 512.46 92602 39.3 7.87 13.78 1.07 345 .27 59599 35.6 1311681 6.95 14.09 3.38 234 .04 72453 36.0 631908 2650 7.33 14.23 1.17 348 . 33 67925 41.1 6.95 14 .60 2.14 348.47 42631 24.7 871175 14 .88 0.93 5652 40.5 883080.3 7.25 15.42 2. 22 39650 32.9 981578.5 6.93 16 .18 1.68 48033 30.3 1730527 17.23 403.78 80756 6.79 2.81 67403 80597 32.4 7.37 18.43 1.09 339.94 60928 0 .64 400.82 73762 43.5 832853 2575 20.76 41.6 1032112 2400 97 28.81 1.77 326.54 64225 31.4 15 78369 10 points Data Sheet1 + Ready 12Accessibility: Good to go + 100% Report: Write a 750-word statistical report that includes the following sections: Section 1: Scope and descriptive statistics Section 2: Analysis Save and Close Submit X P W & ? S itv Macintosh HD... C D X Assignment Content Review the Wk 2 - Apply: Statistical Report assignment. In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft Excel. Answer the questions below in your Microsoft Excel sheet or in a separate Microsoft 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." . 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. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable's dispersion? Why? Create a 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? Submit your assignment. Resources . Pastas R Us, Inc. Database Center for Writing Excellence Reference and Citation Generator Grammar Assistance Macintosh HD