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
