Week 4- Excel Problems

Q. 15 R square for Linear regression models for predicting sales as a function of the Radio and TV Ads is 0.57948, Linear regression models for predicting sales as a function of the Newspaper ads is 0., and the multiple R square for both independent variables is 0.. These indicate the strengths of association between the dependent and independent variable with the R square value of 0. value describing the independent variable Multiple linear regression forms the residuals for regression assumption. They depict a curvilinear relationship with no clear pattern in the distribution Q. 18 b. The best model for predicting current salary is the logistic regression model. Salary may not be constant, and according to NCSS statistics. Com (n.d.), logistic regression analysis studies the association between a categorical dependent variable and a set of independent and explanatory variables. It provides confidence intervals on predicted values and provides ROC curves to help determine the best cutoff point for classification, allowing you to validate your results Chapter 9 Question 4; Three months MAD had fewer individual errors based on the actual values versus forecast values due to the short periods it had. That is why it yielded better results compared to the 12-month moving average.