Datcb565 Competency 1 Assessment

Pastas R Us Data Analysis Template Data Analyses Perform the data analysis using the Pastas R Us Data file, including the following: • Calculate the annual sales for each restaurant (SqFt × Sales/SqFt). The first value is provided. Hint: For the input range, click on the cell where the first value is given and then drag and drop. This will complete all the calculations. • Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each variable. Hint: To add values into the Function Arguments dialog box, click on the cell where the first value is given and then drag and drop. This will complete all the calculations. • Create a boxplot for Annual Sales. • Create a histogram for Sales/SqFt. Complete an AI-supported analysis of the Pastas R Us data using Microsoft Copilot or another AI chat tool of your choice, including the following: • Upload your complete Excel file to your AI chat. • Prompt the AI to suggest explanations and analysis of your boxplot and histogram. • Prompt the AI to write plain language interpretations of the skew, dispersion, and outliers. Reflection Data Analysis Reflect on the following prompts based on your independent analysis of the Pastas R Us data: