Question 6
Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.
| Regression Statistics | |
|---|---|
| Multiple R | |
| R Square | |
| Adjusted R Square | 0.97 |
| Standard Error | 3.36 |
| Observations |
ANOVA
| df | SS | MS | F | |
|---|---|---|---|---|
| Regression | Q2 | Q5 | ||
| Residual | Q1 | Q3 | ||
| Total | Q4 |
| Coefficients | Standard Error | t Stat | P-value | |
|---|---|---|---|---|
| Intercept | 23.8 | 13.2 | 0.32 | |
| No. of BAB made | 0.18 | 0.05 | 0.17 | |
| No. of TACC made | 0.32 | 0.16 | 0.3 | |
| No. of HAD made | -0.008 | 0.1 | 0.95 |
Figure-2: Partial Regression Output from Excel
What is the value of Q3? (Note: Enter your answer rounded to two decimal places. For example, if your answer is “1.235” then enter it as “1.24”)