Purchase Solution

Multiple Regression Analysis - Transform Log-Linear Model

Not what you're looking for?

Ask Custom Question

The manager of Collins Import Autos believes the number of cars sold in a day (Q) depends on two factors: (1) the number of hours the dealership is open (H) and (2) the number of salespersons working that day (S). After collecting data for two months (53 days), the manager estimates the following log-linear model: Q= aHbSc

a) Explain how to transform this log-linear model into a linear form that can be estimated using multiple regression analysis.

The computer output for the multiple regression analysis is shown below:

Dependent Variable: LNQ R Sqaure F Ratio P-Value on F

Observations: 53 0.5452 29.97 0.0001

Variable Parameter Standard
Estimate Error T-Ratio P-Value

Intercept 0.9162 0.2413 3.80 0.0004

LNH 0.3517 0.1021 3.44 0.0012

LNS 0.2550 0.0785 3.25 0.0021

b). How do you interpret coefficients b and c.? If the dealership increases the number of salespersons by 20 percent, what will be the percentage increase in daily sales?

c.) Test the overall model for statistical significance at the 5 percent significance level.

d.) what percent of the total variation in daily auto sales is explained by this equation? What could you suggest to increase this percentage?

e.) Test the intercept for statistical significance at the 5 percent level of significance. If H and S both equal 0, are sales expected to be 0? Explain why or why not.

f. Test the estimated coefficient b for statistical significance. If the dealership decreases its hours of operation by 10 percent, what is the expected impact on daily sales?

(Attached is my problem).

Attachments
Purchase this Solution
Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • File SAS and conduct a multiple linear regression analysis

    Use Proc Reg to run a multiple linear regression model. I have attached an Excel sheet with the outputs and explanations for reading your findings. The expert reads a file into SAS and conducts a multiple linear regression analysis.

  • Biostatistics - Multiple Regression Analysis

    357241 Biostatistics - Multiple Regression Analysis See attached files. This is an exercise requiring multiple regression analysis to be used. Details of requirements are in "The task" section of attached Asst7 document.

  • Multivariate Statistics

    a) Heirarchical Multiple Regression b) Stepwise Regression c) Backwards Regression d) Linear Models Regression Question 4 What is a common criticism of the STEPWISE method of variable selection?

  • Correlation and Regression Analysis

    Then, build a multiple regression model. Which model do you prefer? 3. Predict the ?taste? of a cheese where (log) acetic is 5.3, (log) h2s is 8.0 and lactic is 3.0. What do you think of this model? 4.

  • Economics- Regression Created

    function rather than addition function, we run log-log multiple regression.

  • Multiple Regression Analysis: Average Miles Per Gallon

    The expert examines multiple regression analysis for the average miles per gallon.

  • Statistics regression problem samples

    So, more variables are to be included in the model. 10-82 To regress log Y on X, enter X and Y values in an excel sheet. Transform Y value to log Y values.

  • Testing coefficients for linear regressions

    Following are results of a linear trend model on log-normal stock prices (see attached file for prices). a) State the log-linear equation. b) Estimate the stock price for the next quarter. c) Identify one error that could invalidate the model.

  • Least-Squares Property and Regression Analysis

    This week we looked at regression analysis. What is the difference between a simple regression analysis and multiple regression? Please give examples. 1.

View More Related Solutions