Please answer the following questions accordingly. Thanks
Sheet1
| You have been provided with the following dataset, which includes the monthly sales figures (in thousands of dollars) for a retail company over the past two years: | |
| Month | Sales ($’000) |
| January | 35 |
| February | 40 |
| March | 38 |
| April | 45 |
| May | 50 |
| June | 42 |
| July | 48 |
| August | 53 |
| September | 47 |
| October | 55 |
| November | 60 |
| December | 62 |
| January | 52 |
| February | 57 |
| March | 54 |
| April | 60 |
| May | 63 |
| June | 58 |
| July | 61 |
| August | 65 |
| September | 59 |
| October | 66 |
| November | 70 |
| December | 72 |
| Assignment Questions: | |
| 1. Calculate Descriptive Statistics | |
| Using Excel, calculate the following descriptive statistics for the sales data: | |
| Mean | |
| Median | |
| Mode | |
| Standard deviation | |
| Minimum and maximum sales values | |
| Range | |
| 2. Visual Representation | |
| Create a histogram chart of the sales data to visualize the distribution. | |
| 3. Analysis | |
| Based on the descriptive statistics and the histogram, describe the overall trend in the sales figures over the two-year period. Discuss whether the data appears to be normally distributed or skewed, and what that might imply about the sales performance of the company. (insert your answer below) | |
| Instructions: | |
| Use Excel’s built-in functions to calculate the descriptive statistics. | |
| Ensure your histogram is properly labeled and formatted. | |