Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IBM Stock Prices September 2022 Date Closing Price Volume Open Day High Day Low 29-Aug-22 $130.31 2,781,959 $129.99 $131.42 $129.57 30-Aug-22 $129.58 2,407,845 $130.56 $130.77

IBM Stock Prices September 2022
Date Closing Price Volume Open Day High Day Low
29-Aug-22 $130.31 2,781,959 $129.99 $131.42 $129.57
30-Aug-22 $129.58 2,407,845 $130.56 $130.77 $129.29
31-Aug-22 $128.45 3,488,512 $129.92 $130.00 $128.40
1-Sep-22 $129.66 3,396,125 $128.40 $129.82 $127.74
2-Sep-22 $127.79 3,040,694 $130.30 $130.56 $127.24
6-Sep-22 $126.72 3,346,758 $127.80 $128.06 $126.30
7-Sep-22 $127.71 2,401,360 $126.69 $127.87 $126.28
8-Sep-22 $128.47 2,964,029 $127.20 $128.54 $126.59
9-Sep-22 $129.19 3,292,947 $128.90 $129.49 $128.06
12-Sep-22 $130.66 3,741,133 $130.33 $130.99 $129.89
13-Sep-22 $127.25 4,565,199 $129.14 $129.91 $126.77
14-Sep-22 $127.69 3,818,620 $127.50 $129.00 $126.84
15-Sep-22 $125.49 5,141,378 $127.39 $127.47 $124.90
16-Sep-22 $127.27 9,839,672 $124.36 $127.53 $123.83
19-Sep-22 $127.73 3,981,382 $126.49 $128.06 $126.28
20-Sep-22 $126.30 2,837,434 $126.90 $126.99 $125.52
21-Sep-22 $124.93 3,388,808 $126.89 $127.84 $124.92
22-Sep-22 $125.31 4,046,730 $124.76 $126.51 $124.41
23-Sep-22 $122.71 5,195,626 $124.53 $125.00 $121.74
26-Sep-22 $122.01 3,987,491 $122.30 $124.26 $121.75
27-Sep-22 $121.74 4,116,927 $122.60 $123.95 $121.08
28-Sep-22 $122.76 4,996,348 $121.65 $123.23 $119.81
29-Sep-22 $121.63 3,815,428 $121.85 $122.62 $120.57
30-Sep-22 $118.81 5,345,884 $121.66 $122.43 $118.61

The attached IBM Stock file contains information on IBM stock prices in September of 2022. Treat this as a sample of IBM stock prices for 2022. (Your population of interest would be the 2022 IBM stock prices.)

Use Excel Data Analysis to find the mean, median, and mode for both the Daily High and Daily Low prices. Make sure that you clearly state or point out which numbers are which. Dont expect me to pick the numbers I want.

Use Data Analysis to construct a 95% confidence interval for Closing Price. Interpret the interval.

Use Data Analysis to construct a 99% confidence interval for Closing Price. Interpret the interval.

Compare the widths of the 95% and 99% confidence intervals.

Use Data Analysis to construct a 98% confidence interval for Volume. Interpret the interval.

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

Shrimply Inflation

Authors: Eiche Gardner

1st Edition

B0BYLXHYCY, 979-8386901233

More Books

Students also viewed these Finance questions

Question

Of the 15 applicants, seven are qualified.

Answered: 1 week ago