Case I – Select a major company and perform some descriptive statistics regarding its annual revenues over any past ten calendar years between 2000 and 2022. List the revenues by year and the source of the information. Then, calculate the population standard deviation of the revenues by year, calculate the mean revenue of the data set, calculate the median revenue of the data set, the mode, 1st quartile and 3rd quartile. Generate a descriptive statistics summary using Analysis Toolpak, then draw a box and whiskers diagram of the data set.
All formula calculations must be shown in Excel – any answers provided that do not have all supporting calculations shown will receive no credit.
Select a second company: Perform the same calculations in Excel.
Then compare the standard deviations of the two companies and analyze as to which company, if this history is a good predictor of future performance next year, is riskier in terms of sales revenues, justifying your answer. Write your answer in full sentences in a paragraph-format as it relates to the case. Do not provide generic answers, definitions, or answers retrieved from other sources unrelated to the case. Your answer should be derived from the numbers and statistics you just generated, not based on the fame/reputation of the company itself. The answer to this question can be written in a block in the same excel file.
