Fit a multiple regression plane from raw data and interpret each coefficient correctly.
Variables in This Problem
Dependent Variable
\[
Y=\text{Monthly food expenditure in Rs. }100
\]
First Independent Variable
\[
X_1=\text{Monthly income in Rs. }1000
\]
Second Independent Variable
\[
X_2=\text{Size of family}
\]
We fit:
\[
\hat{Y}=A+BX_1+CX_2
\]
by using the three normal equations.
Calculator reminder: because most calculators allow only two-variable statistics mode, collect sums by entering \(X_1,X_2\), then \(Y,X_2\), then \(Y,X_1\). Rename the calculator outputs carefully.
Question 23: Linear Regression Plane
Raw Data • Multiple Regression • Prediction
A household survey on monthly expenditure on food yielded the following data.
Find the linear regression plane to predict monthly expenditure.
Also predict monthly food expenditure when \(X_1=6\) and \(X_2=8\).
Monthly Expenditure \(Y\) Rs. 100
10
15
20
25
30
35
40
Monthly Income \(X_1\) Rs. 1000
2
4
5
7
6
6
5
Size of family \(X_2\)
4
5
7
10
8
11
4
✓
Enter your answer first.
Correct answer: \(3.345\)
✓
Enter your answer first.
Correct answer: \(6.796\)
✓
Enter your answer first.
Correct answer: \(-1.761\)
✓
Enter your answer first.
Correct answer: \(30.04\)
✓
Select your answer first.
Correct answer: Predicted expenditure increases by about Rs. \(679.60\) when income increases by Rs. \(1000\), keeping family size constant.
✓
Select your answer first.
Correct answer: The fitted model shows a decrease of about Rs. \(176.10\) for one extra family member, keeping income constant.
Try once before opening the solution
Collect the sums first. Then form the three normal equations and solve for \(A\), \(B\), and \(C\).
\(B=6.796\) means predicted monthly food expenditure increases by about \(6.796\) hundreds of rupees, that is about Rs. \(679.60\), when monthly income increases by Rs. \(1000\), keeping family size constant.
\(C=-1.761\) means this fitted model predicts a decrease of about \(1.761\) hundreds of rupees, that is about Rs. \(176.10\), for one extra family member, keeping income constant.
This negative sign should be interpreted cautiously because it comes from the given sample and the relationship between the two independent variables.
Final Answer
Regression plane: \(\hat{Y}=3.345+6.796X_1-1.761X_2\)Predicted expenditure for \(X_1=6,\ X_2=8\) is \(30.04\) hundreds of rupees.Predicted expenditure \(=\text{Rs. }3004\).
Video Solution
In this video, we solve the household survey multiple regression problem by normal equations.