Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BT A B C 1 Age Cost 2 28 2.46 25 11.07 25 11.07 22 11.07 19 11.07 23 11.07 24 11.07 17 2.46 17
BT A B C 1 Age Cost 2 28 2.46 25 11.07 25 11.07 22 11.07 19 11.07 23 11.07 24 11.07 17 2.46 17 4.92 11 16 1.23 12 24 4.92 13 19 8.61 14 21 3.69 15 17 7.38 16 19 4.92 17 26 8.61 18 16 1.23 19 27 3.69 20 29 2.46 21 22 3.69 22 20 9.84 23 19 2.46 24 20 12.3 25 29 1.23 26 28 11.07 27 16 1.23\fA B 50 19 1.23 51 27 2.46 52 27 1.23 53 23 6.15 54 16 7.38 55 27 8.61 56 18 3.69 57 16 4.92 58 17 12.3 59 28 4.92 60 25 6.15 61 23 1.23 62 22 11.07 63 24 1.23 64 23 8.61 65 25 11.07 66 24 11.07 67 18 3.69 68 21 3.69 69 28 6.15 70 24 6.15 71 24 3.69 72 29 7.38 73 23 12.3 74 21 4.92 75 29 12.3 76 16 11.07 77D 74 21 4.92 75 29 12.3 76 16 11.07 24 9.84 78 23 6.15 79 17 12.3 80 17 2.46 81 25 11.07 82 25 3.69 83 23 11.07 84 24 3.69 85 26 9.84 86 29 11.07 87 27 9.84 88 27 8.61 89 28 1.23 90 19 3.69 91 19 11.07 92 23 8.61 93 27 12.3 94 28 11.07 95 16 4.92 96 19 4.92 97 20 9.84 98 19 1.23 99 27 11.07 100 25 6.15JI 92 23 8.61 93 27 12.3 94 28 11.07 95 16 4.92 96 19 4.92 97 20 9.84 98 19 1.23 99 27 11.07 100 25 6.15 101 19 11.07 102 103 104QueStlon 12 7 points Save Answe A UQ student is looking to develop a model to predict the cost of breakfast for students, as measured in AUD ($), based on the age of the students. The Excel data file Breakfastxlsx located in the LBRT #3 > LBRT #3 Data Files, contains these data for 100 students. Use Excel Data Analysis to estimate a linear model for the relationship, as well as a 94% confidence interval for the slope and a residual plot. State all numerical answers below correct to four decimal places using the Excel output results. 'I. the intercept 2. the slope coefficient , and 3. the standard error of the estimate 4. Using this model, predict the cost of breakfast for a student that is 35 years old. Use all decimal places in your calculation by selecting and using the values of b0 and b1 in the output generated by Excel. 5. Does the prediction involve extrapolating the relationship? Type yes or no. u) From the output for 94% confidence interval for the slope coefficient report 6. the lower bound and 7. the upper bound
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