A B C D E F G H You have the data of the price of an item and the demand for organic bread Price Demand a) $4.04 46, 108.63 a) Copy this worksheet, name it Pr1.1 plot a scatter $9.70 40, 703.64 plot and use a trend line to create a equation for the $6.72 43,545.36 trend. Explain the equation and R2 value $6.09 44,051.67 b) Copy this worksheet and name it as Pr1.2. Use $7.88 42,502.12 the manual calculation method to calculate the $8.64 41,510.44 equation, R2, R, Standard error and 95% confidence $5.83 44,556.93 intervals 10 $9.69 40,652.34 c) Copy this worksheet and name it as Pr1.3. Use $2.77 47,502.39 th 12 $9.09 41,054.32 the solver to find the intercept and slope of the data 13 $7.38 42,774.24 points and the predicted demand 14 $8.94 41,532.52 d) Copy this worksheet and name it as Pr1.4. Use 15 $7.03 43,139.8 the trend function to find the predicted demand 16 $6.95 43,480.77 17 $7.02 43,417.34 values. 18 $9.23 41,238.48 e) Copy this worksheet and name it as Pr1.5. Use 19 $9.02 41,096.60 the data analysis tool pack Regression function.' 20 $2.45 47,810.99 Explain the plots you generated with the function 21 $5.80 44,343.99 and tell me if the data falls within all the 22 $4.71 45,707.74 assumptions. Finally create a predicted demand and 23 $4.52 45,659.50 the 95% confidence interval for the demand 24 $3.02 47,144.01 25 $5.34 45, 156.28 26 $6.43 43,906.35 27 $3.60 46,832.20 28 $3.39 46,957.39 29 $7.80 42,425.68 30 $8.12 42,324.01 31 $6.07 44,287.55 32 $8.86 41,359.97 $3.56 46,728.76 34 $6.01 44,150.04 35 $9.95 40,291.10 36 $9.37 40,752.22 37 $3.66 46,457.50 38 $3.89 46,349.32 39 $9.68 40,686.40 40 $8.94 41,542.63 41 $9.02 41,456.72 42 $9.88 40,279.86 43 $5.80 44,560.95 44 $5.19 45,163.03 45 $2.53 47,659.05 46 $2.51 47,644.88 47 $5.20 45,165.38 48 $5.35 44,896.54 49 $4.63 45,791.25 50 $5.69 44,443.89 51 $7.00 43,172.32 52 $6.94 43,270.38 53 $5.98 44,393.62