Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Interpreting QA output in Excel
| Share |

Forum Topic | Post Reply Login |

## Interpreting Qa Output In Excel | Rate this: (3/5 from 1 vote) |

Ok, I have a set of data in Excel and I then ran a multiple regression (also in Excel) but I don't know how to interpret the analysis of the statistical results. e.g The null hypothesis as it related to coefficients etc. Furthermore I have to make an economic or business analysis of the result. I don't know if this is the right place to ask for help (apologies if it isn't. I'm very sorry) but if there is anyone willing to help, I will gladly post the excel sheet (with data and regression result) here. Thanks. HappyPpl. | ||

Posted by HappyPpl on |

Replies - Displaying 1 to 8 of 8 | Order Replies By: Most Recent | Chronological | Highest Rated |

Rate this: (3/5 from 1 vote) Multiple regression analysis assumes that data is numerical in nature (quantitative). If your input data is qualitative (such as Questions and Answers which I have interpreted 'QA output' as) then it is necessary to convert the data into numerical equivalents that can then be used as predictive components within the regression equation. For example, if the the answer can be dissatisfied, neutral or satisfied then this can be converted to a scale of 0-2 to represent the level of satisfaction. | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Rate this: (3/5 from 1 vote) I was able to do the regression in Excel but I'm truly at sea as to how to properly interpret this. I used Price ($) as my dependent (Explained variable) Y axis then the rest as independent (Explanatory variables) X axis. Is this also correct? Thanks. Can you help take a look at this and interpret using the questions below? Regression output Questions: A) Perform a multiple regression to explain the price of houses (US dollars) using whatever variables you wish from the data provided. -Based on this regression, prepare a report containing the following sections: 1. An analysis of the statistical results. You should cover such questions as the null hypothesis as it relates to coefficients, the sign (+/–) of coefficients, the meaning of the estimated coefficients as well as the overall predictive ability of the regression. 2. An economic or business analysis of the results. What do you conclude in general from the regression? | |

Posted by HappyPpl on |

Rate this: (3/5 from 1 vote) Here again as a word document and I hope it does make sense.
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Posted by HappyPpl on |

Rate this: (3/5 from 1 vote) The set up is correct to predict house prices based on the independent variables. The null hypothesis requires a confidence level to be set (usually 95% at 2 standard deviations) to test whether or not (null hypothesis) that house price can be explained by the external factors at that level of confidence. The overall predictive ability is the R-squared. The coefficients of each independent variable (+ or -) represent the relationships e.g. as Age increases, price decreases by a factor of 333. While the analysis toolpak performs the raw regression analysis, it does not provide very useful descriptive information in order to interpret the results and validity of them. I suggest that you download and use our template from here which can be used fully for 30 days to conduct your analysis and provide advanced descriptive information as well as the ability to forecast for economic or business analysis. | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Rate this: (3/5 from 1 vote) I have used the template you mentioned but I got these two errors Runtime Error "6" overflow and Error "13". What do these errors indicate and how can they be resolved? Thanks. | |

Posted by HappyPpl on |

Rate this: (3/5 from 1 vote) The overflow error is likely to be due to the previous error but may be due to a problem in calculating the number of observations or variables. You can send through your template as an attachment as a reply to the notification email of this post so that we can investigate, resolve and post the solution here for you. | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Rate this: (3/5 from 1 vote) I have sent the data/template as an attachment to as a reply to the e-mail notification as requested.
Could you kindly help check and resolve?
Thanks.
HappyPpl. | |

Posted by HappyPpl on |

Rate this: (3/5 from 1 vote) | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Displaying page 1 of 1 |

Find relevant Excel templates and add-ins for Interpreting QA output in Excel in the Excel Business Solutions Directory |