Question: procedure: Go to the website: https:/ /ca.finance.yahoo.com/ - In the top left corner, in the box where it says Enter Symbol, type in SU.TO. Click

 procedure: Go to the website: https:/ /ca.finance.yahoo.com/ - In the top

left corner, in the box where it says Enter Symbol, type in

procedure: Go to the website: https:/ /ca.finance.yahoo.com/ - In the top left corner, in the box where it says Enter Symbol, type in SU.TO. Click on Look Up. You will be directed to the summary page for Suncor Energy Inc. In the left side menu, click on the link for Historical Prices. You can now select a date range to look up. * Start with January 1, and end with December 31. Select any year between 2000 and 2013. For example, if you wanted to look up the price information for the year 2007, you would enter January 1, 2007 and December 31, 2007. * On the right hand side, select Weekly. Click Get Prices. Export the data to a spreadsheet by scrolling down to the bottom of the page and clicking on Download to Spreadsheet. - Select one of the columns labeled Open, High, Low, or Close to be your data set (ignore the columns for Date, Volume and Adj. Close). Copy and paste your selected column into a new spreadsheet. Complete each of the following. Include your output, and remember to show your work where applicable. a) Use EXCEL to find the mean, median, and standard deviation. b) By hand, calculate the interquartile range. Show your work. c) By hand, use the procedure for Outliers described on page 141 to determine whether your data set contains any outliers. Show your work. d) Copy your summary statistics onto the same spreadsheet as your data. Print this page and include it in your solutions. (For the sake of saving paper, once you have finished your calculations you may wish to condense your data into two shorter columns)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!