Solved by verified expert:this is an essay based on a case study for a business statistics class, I will upload an excel sheet picture that contains information of what the essay should be about.I will also upload the original case study rubric.the opinion on the essay should talk about what I think of the riskiness of the standard deviation.its a one page essay, single spaced.
excel_sdy.docx
chapter_1_case_study_grading_rubric_01192018.pdf
Unformatted Attachment Preview
CHAPTER 1
OVERVIEW AND BASICS
Compare and contrast the riskiness of two similar financial “instruments.” For example, compare
and contrast the riskiness of the stocks of two major corporations, two retirement investment funds,
two corporate bonds, etc. Download the instrument prices for the last 30 business trading days, and
compute each’s population standard deviation, mean, and median.
Record the data and perform the calculations using Excel. On a separate sheet of paper, sketch a
box and whiskers diagram for the range of each’s values during that 30 day period. Write an essay
(using a word processor) of about one page (single spaced) with your opinions. Email the Excel file
to the instructor and turn in the paper to the instructor.
CASE STUDIES: CHAPTER 1 GRADING RUBRIC
Student name:
Do both instruments have a population standard deviation calculated using Excel. 2 pts.
_____
Do both instruments have a mean calculated using Excel. 2 pts. _____
Do both instruments have a median calculated using Excel. 2 pts. _____
Is there a box and whiskers diagram accurately sketched. 2 pts. _____
Does the essay justify the opinion of the student as to which instrument is riskier. 2 pts.
_____
…
Purchase answer to see full
attachment
