Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Statistical Reasoning For Everyday Life

Authors: Jeffrey Bennett, William L. Briggs, Mario F. Triola

4th International Edition

0321904648, 9780321904645

Students also viewed these Mathematics questions