STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 14, Problem 8E
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars.
x1 is the number of architects employed by the company.
x2 is the number of engineers employed by the company.
x3 is the number of years involved with health care projects.
x4 is the number of states in which the firm operates.
x5 is the percent of the firm’s work that is health care–related.
- a. Write out the regression equation.
- b. How large is the sample? How many independent variables are there?
- c. Conduct a global test of hypothesis to see if any of the set of regression coefficients could be different from 0. Use the .05 significance level. What is your conclusion?
- d. Conduct a test of hypothesis for each independent variable. Use the .05 significance level. Which variable would you consider eliminating first?
- e. Outline a strategy for deleting independent variables in this case.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
- х
i
Data Table
ets
he
Full data set O
Assets
R&D Expense
R&D Expense
712.087
Assets
3,478.557
3,462.224
1,206.455
345.709
7,785.525
389.959
918.899
90.404
117.895
2,390.016
257.571
446.339
47.523
678.531
71.401
1,069.117
2,465.859
3,945.287
168.631
111.724
2,648.273
3,406.446
9,250.323
292.876
224.715
383.186
nt
410.051
988.349
19.257
485.204
55.161
493.116
55.046
2,363.477
251.699
0)
102.148
13.489
221.321
27.958
3,728.419
1,389.377
1,706.486
327.691
1,465.861
158.293
141.616
165.093
19.154
161.317
2,988.141
301.803
nat
Print
Done
Rick is a school principal, and he is trying to decide if there is a relationship between conduct infractions
and the number of students present at school during the day when infractions occur. How should he set
up a scatterplot to help him see if there is a relationship?
O plot the number of infractions on the y-axis and the number of students present on the x-axis
O plot the number of infractions on the y-axis and the day of the week on the x-axis
O plot the number of infractions on the x-axis and the number of students present on the y-axis
O plot the number of infractions on the x-axis and the day of the week on the y-axis
A real estate agent wanted to find the relationship between sale price of houses and the size of the house.
She collected data on two variables recorded in the following table for 15 houses in Seattle. The two variables
are
PRICE= Sale price of houses in thousands of dollars
SIZE= Area of the entire house in square feet.
PRICE
455
278
463
327
505
264
445
346
487
289
434
411
223
323
488
250
225
290
180
320
240
270
205
285
240
260
230
170
230
298
SIZE
a) Using MICROSOFT EXCEL- run the above regression and copy the output into your assignment word document
from which you can write down the least square regression line. Write down the least square regression line
from that specific output. USE THE NAME OF VARIABLES WHEN YOU WRITE THE EQUATION.
b) Interpret the slope and constant term with proper UNITS assigned.
c) Comment on the explanatory power of the regression model from the required output. Copy that specific
output into your assignment word document.
Now to increase the explanatory…
Chapter 14 Solutions
STAT TECH IN BUSINESS & ECON AC
Ch. 14 - There are many restaurants in northeastern South...Ch. 14 - Prob. 1ECh. 14 - Thompson Photo Works purchased several new, highly...Ch. 14 - A consulting group was hired by the Human...Ch. 14 - Cellulon, a manufacturer of home insulation, wants...Ch. 14 - Refer to Self-Review 141 on the subject of...Ch. 14 - Prob. 5ECh. 14 - Prob. 6ECh. 14 - Prob. 3SRCh. 14 - Given the following regression output, answer the...
Ch. 14 - The following regression output was obtained from...Ch. 14 - A study by the American Realtors Association...Ch. 14 - The manager of High Point Sofa and Chair, a large...Ch. 14 - Prob. 10ECh. 14 - Prob. 11ECh. 14 - A real estate developer wishes to study the...Ch. 14 - Prob. 13CECh. 14 - Prob. 14CECh. 14 - Prob. 15CECh. 14 - Prob. 16CECh. 14 - The district manager of Jasons, a large discount...Ch. 14 - Suppose that the sales manager of a large...Ch. 14 - The administrator of a new paralegal program at...Ch. 14 - Prob. 20CECh. 14 - Prob. 21CECh. 14 - A regional planner is studying the demographics of...Ch. 14 - Great Plains Distributors, Inc. sells roofing and...Ch. 14 - Prob. 24CECh. 14 - Prob. 25CECh. 14 - Prob. 26CECh. 14 - Prob. 28CECh. 14 - Prob. 29CECh. 14 - The director of special events for Sun City...Ch. 14 - Prob. 31CECh. 14 - Prob. 32CECh. 14 - Prob. 33DACh. 14 - Prob. 34DACh. 14 - Prob. 35DACh. 14 - Prob. 1PCh. 14 - Quick-print firms in a large downtown business...Ch. 14 - The following ANOVA output is given. a. Compute...Ch. 14 - Prob. 1CCh. 14 - Prob. 2CCh. 14 - Prob. 3CCh. 14 - In a scatter diagram, the dependent variable is...Ch. 14 - What level of measurement is required to compute...Ch. 14 - If there is no correlation between two variables,...Ch. 14 - Which of the following values indicates the...Ch. 14 - Under what conditions will the coefficient of...Ch. 14 - Given the following regression equation, = 7 ...Ch. 14 - Given the following regression equation, = 7 ...Ch. 14 - Given the following regression equation, = 7 ...Ch. 14 - Prob. 1.9PTCh. 14 - In a multiple regression equation, what is the...Ch. 14 - Prob. 1.11PTCh. 14 - Prob. 1.12PTCh. 14 - For a dummy variable, such as gender, how many...Ch. 14 - What is the term given to a table that shows all...Ch. 14 - If there is a linear relationship between the...Ch. 14 - Given the following regression analysis output: a....Ch. 14 - Given the following regression analysis output. a....
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- DVD Player sales The table shows the number of DVD play-ers sold in a small electronics store in the years 2003-2013. What was the average rate of change of sales between 2003 and 2013? Whatwas the average rate of change of sales between 2003 and 2004? What was the average rate of change of sales between 2004 and 2005? Between which two successive years did DVD player sales increase most quickly?arrow_forwardHeart Disease In a certain country, the number of deaths due to heart disease decreased from 235 in one year to 221 in the next year. What percentage decrease in deaths due to heart disease does this represent?arrow_forwardDraw a scatter diagram with square feet of living space as the independent variable and selling price as the dependent variable and describe variable and describe the relationship between the size of a house and the selling price.arrow_forward
- The director of an alumni association for a small college wants to determine whether there is any type of relationship between the amount of an alumnus’s contribution (in dollars) and the years the alumnus has been out of school. The data follow. What is the value of r? Years x 1 5 3 10 7 6 Contribution y 500 100 300 50 75 80arrow_forwardanswer A,B,C and Darrow_forwardIn multiple regression, when all independent variables are considered but the order in which they are added to the model is determined by the amount it contributes to the dependent variable, it is called: a.Two step b.Stepwise c.Simultaneous d.Backward steparrow_forward
- Data was collected on the number of pairs of shoes people own and the number of miles they walk per week. r2=0.38. Then 38% of the variation in miles walked can be explained by the linear relationship between the in the number of shoes owned and the miles walked. 62% is attributable to other factors. True Or Falsearrow_forwardBelow are the square footages and sale prices (in thousand of dollars) of seven homes. The square footage is the independent variable and sale prices is the dependent variable. Is the relationship significant? If the square footage of a house in the area is 1600, what is the sale price? Using 3% level of significance. SQFT Sale Price ($) 1924 174.9 1592 136.9 2413 275 2332 219.9 1552 120 1312 99.9 1278 145 Leave your sale price in one decimal place. For the relationship question, denote if it is significant or not significant. The square footage of the area is 600, the sale price would be . The relationship between square footage and sale price is .arrow_forwardExplain if two variables consist of nominal data?arrow_forward
- A researcher wonders whether males get paid more, on average, than females at a large firm. She interviews 50 employees and collects data on each employee's hourly wage (Wage in $). years of higher education (EDUC), years of experience (EXPER), age (Age). and a Male dummy variable that equals 1if male, O otherwise. A portion of the data is shown in the accompanying table. EXPER Wage 39.98 23.71 EDUC Age 40 Male 6 39 19.63 11 64 Click here for the Excel Data File a. Estimate: Wage = Po +PEDUC + PEXPER + PAge + PaMale + e. (Negative values should be Indicated by a minus sign. Round your answers to 4 decimal places.) Predicted Wage EDUC EXPER Age Male b. Predict the hourly wage of a 40-year-old male and female employee with 10 years of higher education and 5 years experience. (Round coefficient estimates to at least 4 decimal places and final answer to 2 decimal places.) 40-yoar-old male 40-year-old fermale Predicted Wage per hour per hour c-1. Interpret the estimated coefficient for…arrow_forwardUSING SPSSarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningMathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningElementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY