Statistics - EXCEL

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.

Case II - Suppose that you rented an apartment. You need to furnish the apartment. You

will need to develop a potential expense for each piece of furniture and a total budget.

Develop a hypothetical expense budget having at least 10-line items using the PERT

methodology and compute the expense point where you are at least 90% sure that your

expenses will not exceed this amount. Include all calculations, showing the steps as done in

the class exercise. The standard deviation should be computed, and the z value specified.

For each piece of furniture and the 3-point estimates, include a link to an internet reference

where you retrieved the price estimate.

You can do this below the PERT table.

Solve this exam cases in Excel. Include your name and upload your file.

If you need to include other files, the solution must be shown and uploaded in Excel.