Question
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
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