Module 1 Excel Assignment Solution | You work for a data analytics firm and your consulting team has been tasked with describing data for the Applewood group car lot locations

Module 1 Excel Assignment

You work for a data analytics firm and your consulting team has been tasked with describing data for the Applewood group car lot locations. Create a well-organized Microsoft Excel workbook to perform your calculations alongside a well-organized Microsoft PowerPoint presentation that will answer the following questions. Be sure to save your spreadsheets as an Excel Workbook.

1. Create a frequency and relative frequency distribution for each quantitative variable. Create a histogram and a pie graph for each quantitative variable. Which class has the largest frequency for each variable? Which class has the smallest frequency smallest frequency? Around which values does the data tend to cluster? To answer these questions, use the exercises shown in the online lecture. Specifically, perform these calculations by writing formulas in excel. Get Cardiovascular Exemplars Assignment Help!! Module 1 Excel Assignment
2. Create a frequency polygon for the quantitative variables. What is the mean, median and mode for each quantitative variable? Is the data skewed? If so, is the skewness positive or negative? What is the skewness coefficient?
3. What is the data minimum, maximum and median for your quantitative data? Create a boxplot to display those values. What is the interquartile range of the data, are there any outliers?
4. Create a table in Microsoft Excel illustrating how one would find standard deviation in stepwise fashion. You will need to understand the formula to do this.
5. Create a scatter plot between the profit variable and age variables. Is there a direct or indirect relationship between the two variables? What is the correlation coefficient? Module 1 Excel Assignment
6. About 95% of the data fall between what two values for the quantitative variables? About 70% of the data fall between what two values for the quantitative variables? Explain which rule (Empirical or Chebychev) you used to calculate this outcome and why. What does this say about how the data varies about the mean?
7. Create a frequency and relative frequency table for each qualitative variable. Be sure to create bar graph and pie chart for each variable. Which category has the largest frequency for each variable? Which category has the smallest frequency smallest frequency? Around which categories does the data tend to cluster? To answer these questions, use the exercises shown in the online lecture. Specifically, perform these calculations by writing formulas in excel. Module 1 Excel Assignment
8. Based on the descriptive statistics, what useful advice can you give?