Question: Study the following Excel regression output for an analysis attempting to predict the number of union members in the United States by the size of

Study the following Excel regression output for an analysis attempting to predict the number of union members in the United States by the size of the labor force for selected years over a 30-year period from data published by the U.S. Bureau of Labor Statistics. Analyze the computer output. Discuss the strength of the model in terms of proportion of variation accounted for, slope, and overall predictability. Using the equation of the regression line, attempt to predict the number of union members when the labor force is 110,000.The model was developed with data already recorded in 1,000 units. Use the data in the model asis.

SUMMARY OUTPUT Regression Statistics Multiple F R Square Adjusted R Square Standard Error Observations 0.798 0.636 0.612 258.632 ANOVA Regression Residual Total df 1 15 1756035.529 1003354.471 2759390 MS 1756036 26.25 66890.3 Significance F 0.00012 Intercept Total Employment Coefficients 20704.3805 -0.0390 Standard Error 879.606:7 t Stat P-value 23.540.00000 -5.12 0.00012 0.0076

Step by Step Solution

★★★★★

3.48 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The F value for overall predictability is 2625 with an associa... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

409-M-S-L-R (1192).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

The following data on the number of union members in the United States for the years 1984 through 2008 are provided by the U.S. Bureau of Labor Statistics. Using regression techniques discussed in...

The following data on the number of union members in the United States for the years 1984 through 2012 are provided by the U.S. Bureau of Labor Statistics. Using regression techniques discussed in...

An aircraft company wanted to predict the number of worker-hours necessary to finish the design of a new plane. Relevant explanatory variables were thought to be the planes top speed, its weight, and...

Study the following Excel regression output for an analysis attempting to predict the number of union members by the size of the labour force for selected years over a 30-year period. Analyze the...

#6 Business Statistics with Computer Applications II Problems from book: Chapter 12 (page 523) 12.62, 12.63, 12.65-12.69 Problems not in book: Casting aluminum. In casting metal parts, molten metal...

Q1. Study the following output from a regression analysis to predict y from x. Predictor Coef SE Coef T P Constant 67.231 5 . 046 13 .32 0. 000 X -0 . 05650 0 . 01027 -5.50 0. 000 S = 10.32 R-Sq =...

Study the following Excel regression output for an analysis attempting to predict the number of union members in the United States by the size of the labor force for selected years over a 30-year...

Study the following Excel regression output for an analysis attempting to predict the number of union members in the United Kingdom by the size of the labour force for selected years over a 16-year...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

You bought put options on 1,000 shares of Amazon with a strike of $78 for $4. The current spot price is $45. If the options expire today, your total profits/losses would be______? [note: losses are a...

Van Nostrand Hospital must schedule nurses so that the hospitals patients are provided with adequate care. At the same time, in the face of tighter competition in the health care industry, careful...

13. (Yes/No): Will the Overflow flag be set if you add a negative integer to a negative integer and produce a positive result?

Ensuring that each quality activity is worth the cost is confirmed through: a. the cost of quality b. cost-benefit analysis c. benchmarking d. design of experiments

Can we infer from the data that the proportion of Americans earning at least $75,000 is greater in 2008 than in 2006 (INCOME06)? For each of the following variables, conduct a test to determine...

Conduct a test to determine whether Democrats and Republicans (PARTY: 1 = Democrat and 2 = Republican) differ in their intention to vote (DEFINITE: 1 = Definitely will not vote, 2, 3, 4, 5, 6, 7, 8...

Conduct a test to determine whether Democrats and Republicans (PARTY: 1 = Democrat and 2 = Republican) differ in how much they thought about the upcoming election for president (THOUGHT: 1 = Quite a...

1. Again, the chickenegg problem! A chicken lays a number of eggs, N, which follows a Poisson[)\\) distribution. Each egg hatches a chick with probability 33, independently. Let X be the number of...

Assume Evco, Inc. has a current stock price of $45.37 and will pay a $1.95 dividend in one year; its equity cost of capital is 15%. What price must you expect Evco stock to sell for immediately after...

On July 10, 2012, you purchase a $10,000 par T-note that matures in five years. The settlement occurs on July 11, 2019. The coupon sate is 7 percent and the current price quote is 95 1564 percend The...