Excel Questions Business Analysis HW4

profileAlan7
Home>Homework Answsers>Business & Finance homework help>Operations Management homework help
businessEXCEL

Please answer the following questions accordingly. Thanks

  • 5 months ago
  • 2
Report issue
files (1)

BUSI508Homework4141.xlsx

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.