Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4) Obtain a sample of Suncor Energys financial data for a one-year period by the following procedure: - Go to the website: https://ca.finance.yahoo.com/ - In

4) Obtain a sample of Suncor Energys financial data for a one-year period by the following 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. 2 - 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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics The Exploration & Analysis Of Data

Authors: Roxy Peck, Jay L. Devore

7th Edition

0840058012, 978-0840058010

More Books

Students also viewed these Mathematics questions