Question

In: Accounting

Show the work please Suppose you collected data from 1986 to 2005 to estimate the following...

Show the work please

  1. Suppose you collected data from 1986 to 2005 to estimate the following demand function:

QX = b0 + b1 PX + b2 PR + b3 M

Assume R is a substitute and X is a normal good. The estimation results are reported below:

Dependent Variable: QX

Method: Least Squares

Date: 07/23/06   Time: 11:10

Sample: 1 20

Included observations: 20

Variable

Coefficient

Std. Error

t-Statistic

P-Value

C

19.777074

1.784179

11.0846

0.0000

PX

-13.79169

2.303381

-5.987587

0.0000

PR

5.069939

0.844016

6.006920

0.0000

M

0.257197

0.080063

3.212410

0.0054

R-squared

0.872386

    F-statistic

36.45966

Adjusted R-squared

0.848459

    P-Value for F-statistic

0.0000

           

            a. Conduct t tests to see if the coefficients are statistically significant at the 5% level of significance. Disregard the intercept. Use the p-values. A simple yes or no is not enough. Explain

           

            b. Conduct an F- test to see if the equation, as a whole, is statistically significant at the 5%. Use the p-value. A simple yes or no is not enough. Explain.

                       

Solutions

Expert Solution

a.The t statistics square measure already provided within the output. The t-test tests the alternate hypothesis that the constant of the variable is zero (or the variable is statistically significant).

For Px, p-value for the t-test = zero. At significance level of fifty, 0 < 0.05. so p-value < significance level. thus PX is statistically vital. this can be expected because the value of a standard sensible can have an effect on the demand of the great. If value will increase, individuals wouldn't be ready to purchase the maximum amount of the great s they were shopping for before. it's negatively associated with amount demanded of the traditional sensible.

For PR, p-value for the t-test = zero. At significance level of fifty, 0 < 0.05. so p-value < significance level. thus PR is statistically vital. this can be expected because the value of a complement will increase (decreases), the individuals would be shopping for less (more) of the complement and additional (less) of the traditional sensible. it's completely associated with the quanitity demanded of the traditional sensible.

For M, p-value for the t-test = zero. At significance level of fifty, 0.0054 < 0.05. so p-value < significance level. thus M is statistically vital.

b.The F datum is goven up to thirty six.45966.

The F check tests that the equation as an entire is statistically vital. p-value = zero. SInce p-value of zero < significance level of zero.05, we tend to conclude that the model is important.

c. R sq. is zero.872386. this can be on the point of one. It means the model could be a excellent work. 87.24% of variation within the quantitiy demanded is explained by the freelance variables.

-------------------------------

-------------------------------


Related Solutions

Suppose you collected data from 1986 to 2005 to estimate the following demand function: QX =...
Suppose you collected data from 1986 to 2005 to estimate the following demand function: QX = b0 + b1 PX + b2 PR + b3 M Assume R is a substitute and X is a normal good. The estimation results are reported below: Dependent Variable: QX Method: Least Squares Date: 07/23/06   Time: 11:10 Sample: 1 20 Included observations: 20 Variable Coefficient Std. Error t-Statistic P-Value C 19.777074 1.784179 11.0846 0.0000 PX -13.79169 2.303381 -5.987587 0.0000 PR 5.069939 0.844016 6.006920 0.0000...
******Show work, no Exel/Spss please!!!!****** To answer this question, refer to the following hypothetical data collected...
******Show work, no Exel/Spss please!!!!****** To answer this question, refer to the following hypothetical data collected using replicated measures design. Subject 1 2 3 4 5 6 7 8 9 10 Pre 50 49 37 16 80 42 40 58 31 21 Post 56 50 30 25 90 44 60 71 32 22 a) In a two-tailed test of H 0 using α=0.05, what is p(obtained) for the results shown? *Hint: "two-tailed" means the same thing as nondirectional. ANSWER =...
(Typed work preferable. Show step-by-step please.) 1. Suppose that a researcher collected the following set of...
(Typed work preferable. Show step-by-step please.) 1. Suppose that a researcher collected the following set of data on years of education (X) and number of children for a sample of married adults: X Y 12 2 14 1 17 0 10 3 8 5 9 3 12 4 14 2 18 0 16 2        a. Write out the regression equation, then calculate and interpret the meaning of the regression slope and Y-intercept. You must provide both numbers and careful...
From the data collected below, show how you have followed all 14 of the steps on...
From the data collected below, show how you have followed all 14 of the steps on page 340 to compute the chi-square test of difference by completing the information in the charts below. Answer the hypothesis and interpret your findings. You can use the abbreviations provided in the first chart in Labels column of the second chart. For example, reference Japanese individuals who primarily utilized an action-based strategy to resolve a conflict episode as AJ. Japan (J) United States (U)...
Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will...
Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will cost $10 million. A bank is willing to lend you $7 million for the purchase with equity holders having to provide the remainder of the funds. the terms of the loan are: a 20-year loan with yearly payments at a fixed rate of 3%. You will sell the business after year 8. You estimate the business will have the following profits in years 1-8:...
***Please show the work in Excel*** Use the following data to construct a scatter diagram. Does...
***Please show the work in Excel*** Use the following data to construct a scatter diagram. Does there appear to be a relationship between hours of overtime and number of rejects? Discuss. Hours of Overtime                  Number of Rejects                                     127                                          33                                      90                                           25                                      95                                           23                                     160                                          40                                      10                                           9                                      80                                           19                                      27                                           14                                     103                                          28                                      48                                           19                                      65                                           31
Please show complete work and all calculations Using the following information for a population of data...
Please show complete work and all calculations Using the following information for a population of data points X : n=30 =5   2 =4 ( population variance) A) What is the distribution of the population of sample means? B) Find the probability that the sample mean is less than 4 ?
Please show all work and formulas used. Thanks! The following data are given for an activated...
Please show all work and formulas used. Thanks! The following data are given for an activated sludge process: Q = 5 MGD BOD5 (influent) = 250 mg/L (soluble) BOD5 (effluent) = 20 mg/L (soluble) MCRT = 10 days MLSS in the aeration tank = 2500 mg/L Concentration of SS in the recycle line = 10,000 mg/L Concentration of SS in the effluent = 30 mg/L (70% biodegradable) BOD5/BODu = 0.75, No nutrient limitations. Yield co-efficient, Y = 0.65 Endogenouse decay...
Please show work (i.e. equations used) not just the final answer Use the data from the...
Please show work (i.e. equations used) not just the final answer Use the data from the Table to answer the questions below: Population Statistics for a Hypothetical County Measure Number Measure Number Total 1-year Population 200,000 Number of deaths of persons aged 55 years and older 850 Population of women 15-44 years of age 50,000 Number of deaths of among women aged 55 years and older 460 Population of women 55 years of age or older 55,000 Number one cause...
"Making the Data Work for You" Please respond to the following: As you discovered in this...
"Making the Data Work for You" Please respond to the following: As you discovered in this week's Strayer Story, clothing designer and fashion entrepreneur Deidre Jefferies uses spreadsheet tools daily to organize and analyze data sets in all areas of her business. Share with your instructor and peers your thoughts on the following: 1. Describe one (1) task you could begin working on using Microsoft Excel and/or Google Sheets (in your current job, in this class or another Strayer course,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT