Question: I need help with this question. Data: The data in the excel file elmhurst show family income and university gift aid (non-loan aid) in thousands

I need help with this question.

Data:

I need help with this question.Data: The data in the excel file

The data in the excel file elmhurst show family income and university gift aid (non-loan aid) in thousands of dollars for 50 students in the 2011 freshman class of Elmhurst College in Illinois. ) Find the mean and standard deviation for family income. (Give your answer to the nearest whole dollar.) Mean Income = dollars Standard Deviation = dollars b) Find the mean and standard deviation for University Gift Aid. (Give your answer to the nearest whole dollar.) Mean Gift Aid = dollars Standard Deviation = dollars c) What is the correlation between the variables? (Give your answer to two decimal places.) R = d) Find the least-squares equation for predicting Gift Aid from Family Income. (Give your answers to three decimal places.) y = e) Using the least-squares equation for predicting Family Income from Gift Aid. (Give your answers to two decimal places.) y = f) Predict the amount of Gift Aid for a student whose Family Income is $77000. (Give your answer to the nearest dollar.) Estimated Gift Aid = dollars g) Predict the Family Income for a student that receives $10500 in Gift Aid. (Give your answer to the nearest dollar.) Estimated Family Income = dollars Google Chrome Version 77.0.3865.120 Microsoft Windows 10 Home 32-bit Build 6.2.9200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!