Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4) Obtain a sample of Suncor Energys nancial data for a one-year period by the following procedure: Go to the website: https://ca.nance.yahoo.com/ In the top
4) Obtain a sample of Suncor Energys nancial data for a one-year period by the following procedure: Go to the website: https://ca.nance.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. :5: 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 nd the mean, median, and standard deviation. b) By hand, calculate the interquartile range. Show your work. c) By hand, use the procedure for Outliers 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 nished your calculations you may wish to condense your data into two shorter columns)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started