This assignment is intended to help you learn how to apply s

This assignment is intended to help you learn how to apply statistical This report aims to analyze the operational data of Pastas R Us, Inc., a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. The primary objective is to evaluate the effectiveness of current demographic expansion criteria and the recent Loyalty Card marketing strategy through comprehensive statistical analysis. The dataset comprises data from 74 restaurants, including variables such as average sales per customer, year-on-year sales growth, sales per square foot, Loyalty Card usage percentage, demographic characteristics of the restaurant locations (median age, median income, college-educated adult percentage), and other relevant metrics. The analysis will focus on understanding the relationships among key variables and deriving insights to inform strategic decisions about location expansion and marketing initiatives. Key variables analyzed include: Percentage of college-educated adults (BachDeg%) Median income (MedIncome) Median age (MedAge) Percentage of Loyalty Card usage (LoyaltyCard%) Sales per square foot (Sales/SqFt) Annual sales growth (SalesGrowth%) Descriptive statistics such as means, medians, standard deviations, and graphical representations (histograms and boxplots) were generated using Excel to summarize these variables and assess data distribution and variation. Sample visualizations include bar charts of average sales per sq. ft., histograms of demographic variables, and scatter plots illustrating correlations between variable pairs. Analysis Relationships between Demographics and Sales Performance Using Excel, scatter plots were created to examine the relationships between demographic variables and sales per square foot. The variables analyzed include: BachDeg%