Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 22, 2024

Consider investing in your classmates stock. If you wanted to be 95% sure what the daily change would be, what range for a daily change

Consider investing in your classmates stock. If you wanted to be 95% sure what the daily change would be, what range for a daily change would you expect? Use the Normal Distribution Excel template
Daily Date Open High Low Close Adj Close Volume Change 9/7/2021 3478 3528.090088 3476.939941 3509.290039 3509.290039 2737900 31.2900 9/8/2021 3511.649902 3545.629883 3495.669922 3525.5 3525.5 3053400 13.8501 9/9/2021 3526.02002 3549.98999 3480.370117 3484.159912 3484.159912 2719200 -41.8601 9/10/2021 3501.830078 3508.449951 3462.909912 3469.149902 3469.149902 2393300 -32.6802 9/13/2021 3482.800049 3497.959961 3438 3457.169922 3457.1699222569000 -25.6301 9/14/2021 3475.550049 3486.810059 3437.709961 3450 3450 1936900 -25.5500 9/15/2021 3442.520023485.419922 3402.01001 3475.790039 3475.7900392957500 33.2700 9/16/2021 3459.959961 3492.550049 3446.139893 3488.23999 3488.239992583600 28.2800 9/17/2021 3488.409912 3497.409912 3452.129883 3462.52002 3462.52002 4616600 -25.8899 9/20/2021 3396 3419 3305.01001 3355.72998 3355.729984669100 -40.2700 9/21/2021 3375 3379.699951 3332.389893 3343.629883 3343.629883 2780900 -31.3701 9/22/2021 3351 3389 3341.050049 3380.050049 3380.050049 2411400 29.0500 9/23/2021 3380.050049 3428.959961 3380.050049 3416 3416 2379400 35.9500 9/24/2021 3402.01001 3429.26001 3393.399902 3425.52002 3425.52002 2116200 23.5100 9/27/2021 3371.53415.570068 3339.610107 3405.800049 3405.800049 3634500 34.3000 9/28/2021 3357.709961 3369.189941 3290.100098 3315.959961 3315.959961 4430800 -41.7500 9/29/2021 3322.110107 3351.300049 3297.870117 3301.120117 3301.120117 2562300 -20.9900 9/30/2021 3316 3327.850098 3273.98999 3285.040039 3285.040039 2842400 -30.9600 10/1/2021 3289.01001 3309.1699223255.939941 3283.26001 3283.26001 2835600 -5.7500 10/4/2021 3279.389893 3279.98999 3176.25 3189.780029 3189.780029 4523100 -89.6099 10/5/2021 3204.5 3260.72998 3202.459961 3221 3221 3269200 16.5000 10/6/2021 3213.530029 3264.340088 3198.620117 3262.01001 3262.01001 2533000 48.4800 10/7/2021 3291.540039 3325.75 3283.060059 3302.429932 3302.429932 2409100 10.8899 10/8/2021 3317 3321.429932 3288.199951 3288.520117 3288.6201171995500 -28.3799 10/11/2021 3275 3292.590088 3238.100098 3246.300049 3246.300049 2034200 -28.7000 10/12/2021 3257 3267.530029 3236.280029 3247.330078 3247.330078 1819600 -9.6699 10/13/2021 3269.709961 3288.379883 3261.090088 3284.280029 3284.280029 2420100 14.5701 10/14/2021 3302.449951 3312.600098 3290.780029 3299.860107 3299.860107 2109500 -2.5898 10/15/2021 3311.419922 3410.419922 3304 3409.02002 3409.020025175100 97.6001 Daily Date Open High Low Close Adj Close Volume Change 9/7/2021 3478 3528.090088 3476.939941 3509.290039 3509.290039 2737900 31.2900 9/8/2021 3511.649902 3545.629883 3495.669922 3525.5 3525.5 3053400 13.8501 9/9/2021 3526.02002 3549.98999 3480.370117 3484.159912 3484.159912 2719200 -41.8601 9/10/2021 3501.830078 3508.449951 3462.909912 3469.149902 3469.149902 2393300 -32.6802 9/13/2021 3482.800049 3497.959961 3438 3457.169922 3457.1699222569000 -25.6301 9/14/2021 3475.550049 3486.810059 3437.709961 3450 3450 1936900 -25.5500 9/15/2021 3442.520023485.419922 3402.01001 3475.790039 3475.7900392957500 33.2700 9/16/2021 3459.959961 3492.550049 3446.139893 3488.23999 3488.239992583600 28.2800 9/17/2021 3488.409912 3497.409912 3452.129883 3462.52002 3462.52002 4616600 -25.8899 9/20/2021 3396 3419 3305.01001 3355.72998 3355.729984669100 -40.2700 9/21/2021 3375 3379.699951 3332.389893 3343.629883 3343.629883 2780900 -31.3701 9/22/2021 3351 3389 3341.050049 3380.050049 3380.050049 2411400 29.0500 9/23/2021 3380.050049 3428.959961 3380.050049 3416 3416 2379400 35.9500 9/24/2021 3402.01001 3429.26001 3393.399902 3425.52002 3425.52002 2116200 23.5100 9/27/2021 3371.53415.570068 3339.610107 3405.800049 3405.800049 3634500 34.3000 9/28/2021 3357.709961 3369.189941 3290.100098 3315.959961 3315.959961 4430800 -41.7500 9/29/2021 3322.110107 3351.300049 3297.870117 3301.120117 3301.120117 2562300 -20.9900 9/30/2021 3316 3327.850098 3273.98999 3285.040039 3285.040039 2842400 -30.9600 10/1/2021 3289.01001 3309.1699223255.939941 3283.26001 3283.26001 2835600 -5.7500 10/4/2021 3279.389893 3279.98999 3176.25 3189.780029 3189.780029 4523100 -89.6099 10/5/2021 3204.5 3260.72998 3202.459961 3221 3221 3269200 16.5000 10/6/2021 3213.530029 3264.340088 3198.620117 3262.01001 3262.01001 2533000 48.4800 10/7/2021 3291.540039 3325.75 3283.060059 3302.429932 3302.429932 2409100 10.8899 10/8/2021 3317 3321.429932 3288.199951 3288.520117 3288.6201171995500 -28.3799 10/11/2021 3275 3292.590088 3238.100098 3246.300049 3246.300049 2034200 -28.7000 10/12/2021 3257 3267.530029 3236.280029 3247.330078 3247.330078 1819600 -9.6699 10/13/2021 3269.709961 3288.379883 3261.090088 3284.280029 3284.280029 2420100 14.5701 10/14/2021 3302.449951 3312.600098 3290.780029 3299.860107 3299.860107 2109500 -2.5898 10/15/2021 3311.419922 3410.419922 3304 3409.02002 3409.020025175100 97.6001

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered 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

Recommended Textbook for

Fundamentals of Corporate Finance

Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates

3rd edition

1118845897, 978-1118845899

Students also viewed these Accounting questions

Question

Communication and reporting: What evidence is there that the evaluation communications were adequate in scope and as free as possible from misconceptions, distortions, and errors?

Answered: 1 week ago

Question

★★★★★

In the fall of 1973, University of California Berkeley student admissions data seemed to show a pattern of bias against female graduate students. In spite of the progressive reputation of the...

Answered: 1 week ago

Question

★★★★★

Trust Department of First National Bank service do not grant trust officers any ervice, Dasic and Premier. Trust oustomers discretion in the actions prescribed by the customer and broad discretion in...

Answered: 1 week ago

Question

★★★★★

Let f(x) be the function 1 Then the quotient f(2 + h) - f(2) o + 4 can be h simplified to -1 where ah +b a and b =

Answered: 1 week ago

Question

★★★★★

Exercise 2-7 (Algo) Analyzing account entries and balances LO A1 Use the information in each of the following separate cases to calculate the unknown amount. a. Corentine Company had $170,000 of...

Answered: 1 week ago

Question

★★★★★

Coastal Wineries is a private company looking to seek additional financing for expansion. They have hired your accounting firm for a review engagement. A full audit is not required for the lender....

Answered: 1 week ago

Question

★★★★★

You recently started your new job as a food service worker for a large high school. This week, the ovens and ranges are scheduled for a deep cleaning, but the supervisor who's been training you is...

Answered: 1 week ago

Question

★★★★★

Research a famous physicist and prepare a short biography to share in your portfolio. You can choose to create a short video, a poster, an infographic, a slideshow or other approved applications to...

Answered: 1 week ago

Question

★★★★★

Illustration 11 Mr. PQ has a small trading business for which the following procedures are followed: (1) All collections are deposited with the bank each day. (2) (3) All payments except petty...

Answered: 1 week ago

Previous Question Next Question