Applied Statistics in Business and Economics
5th Edition
ISBN: 9780077837303
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 3CR
(a) Explain how you fit a regression to an Excel
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
I would like to get help to know how to make a report of the multiple regression analysis I performed about 30 employees salaries. it should include a description of the predictice model, pre-analysis, regression analysis, interpretation of the relevant findings and a conclusion with recommendations. thank you
THE QUESTION:
Set up a free RStudio account at posit.cloud. At the start of your R session, you should enter the following commands.
set.seed(1)
e<-rnorm(n = 100,mean = 0,sd = 80)
x<-seq(1,100,1)
y<-10+15*x + e
Follow the examples in the Panopto Videos to use R to obtain the values requested below. (As always, if you round your answers, make sure you do so correctly and keep at least
three decimal places.)
(a) The smallest value of y =
(b) The largest value of y =
(c) The standard deviation of y =
(d) The mean of y =
(e) The median of y =
(f) The correlation between x and y =
(g) Using the variable e as data, the p-value for a test of Ho = 0 vs. Hд μ0 is
ANSWERS I HAVE TRIED
THAT ARE NOT CORRECT ↓
Answer Preview
(BESIDES F, F IS CORRECT)
(A)
-104.123
(B)
1545.84
(C)
448.543
(D)
752.347
(E)
775.533
(F)
(G)
0.987
0.497
PLEASSSEEE DO NOT GIVE ME
BACK THE SAME ANSWERS
THAT I HAVE SAID ARE WRONG
Result
incorrect
incorrect
incorrect
incorrect
incorrect
correct
incorrect
3:23
Search
1 of 2
UMCISI
mville.brightspace.com
onomic Statistics
our grade, can be done as a 2 people's group)
-
Due date Sunday, 12/08/202 through Brightspace portal.
College students' physical, emotional, and mental health are at the forefront of many national
discussions and statistical studies. Many factors can influence students' overall health,
including diet, sleep, exercise, social media usage, etc. In this project, you will look at real data
gathered from 30 college students and determine related descriptive and inferential statistics.
Please use MS Excel (see attached file) to collect your data and complete the assignment.
The students surveyed were asked the following questions:
On a typical weekday,
Are you an on-campus student or a commuter?
How many hours of sleep do you get?
How many hours do you study?
How many calories do you intake?
How many hours do you exercise?
How many hours do you spend on social media?
How many hours do you spend with your friends and family…
Chapter 12 Solutions
Applied Statistics in Business and Economics
Ch. 12.1 - Prob. 1SECh. 12.1 - Prob. 2SECh. 12.1 - Prob. 3SECh. 12.1 - Prob. 4SECh. 12.1 - Prob. 5SECh. 12.1 - Prob. 6SECh. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.2 - Prob. 9SECh. 12.2 - (a) Interpret the slope of the fitted regression...
Ch. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.3 - Prob. 12SECh. 12.3 - Prob. 13SECh. 12.3 - The regression equation Credits = 15.4 .07 Work...Ch. 12.3 - Below are fitted regressions for Y = asking price...Ch. 12.3 - Refer back to the regression equation in exercise...Ch. 12.3 - Refer back to the regression equation in exercise...Ch. 12.4 - Instructions for exercises 12.18 and 12.19: (a)...Ch. 12.4 - Instructions for exercises 12.18 and 12.19: (a)...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.5 - Instructions for exercises 12.23 and 12.24: (a)...Ch. 12.5 - Prob. 24SECh. 12.5 - A regression was performed using data on 32 NFL...Ch. 12.5 - A regression was performed using data on 16...Ch. 12.6 - Prob. 27SECh. 12.6 - Prob. 28SECh. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.7 - Refer to the Weekly Earnings data set below. (a)...Ch. 12.7 - Prob. 33SECh. 12.8 - Prob. 34SECh. 12.8 - Prob. 35SECh. 12.9 - An estimated regression for a random sample of...Ch. 12.9 - An estimated regression for a random sample of...Ch. 12.9 - Prob. 38SECh. 12.9 - Prob. 39SECh. 12 - (a) How does correlation analysis differ from...Ch. 12 - (a) What is a simple regression model? (b) State...Ch. 12 - (a) Explain how you fit a regression to an Excel...Ch. 12 - (a) Explain the logic of the ordinary least...Ch. 12 - (a) Why cant we use the sum of the residuals to...Ch. 12 - Prob. 6CRCh. 12 - Prob. 7CRCh. 12 - Prob. 8CRCh. 12 - Prob. 9CRCh. 12 - Prob. 10CRCh. 12 - Prob. 11CRCh. 12 - Prob. 12CRCh. 12 - (a) What is heteroscedasticity? Identify its two...Ch. 12 - (a) What is autocorrelation? Identify two main...Ch. 12 - Prob. 15CRCh. 12 - Prob. 16CRCh. 12 - (a) What is a log transform? (b) What are its...Ch. 12 - Prob. 40CECh. 12 - Prob. 41CECh. 12 - Prob. 42CECh. 12 - Prob. 43CECh. 12 - Prob. 44CECh. 12 - Prob. 45CECh. 12 - Prob. 46CECh. 12 - Prob. 47CECh. 12 - Prob. 48CECh. 12 - Prob. 49CECh. 12 - Prob. 50CECh. 12 - Prob. 51CECh. 12 - Prob. 52CECh. 12 - Prob. 53CECh. 12 - Prob. 54CECh. 12 - Prob. 55CECh. 12 - Prob. 56CECh. 12 - Prob. 57CECh. 12 - Prob. 58CECh. 12 - Prob. 59CECh. 12 - In the following regression, X = weekly pay, Y =...Ch. 12 - Prob. 61CECh. 12 - In the following regression, X = total assets (...Ch. 12 - Prob. 63CECh. 12 - Below are percentages for annual sales growth and...Ch. 12 - Prob. 65CECh. 12 - Prob. 66CECh. 12 - Prob. 67CECh. 12 - Simple regression was employed to establish the...Ch. 12 - Prob. 69CECh. 12 - Prob. 70CECh. 12 - Prob. 71CECh. 12 - Below are revenue and profit (both in billions)...Ch. 12 - Below are fitted regressions based on used vehicle...Ch. 12 - Below are results of a regression of Y = average...
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
- Is the area to the right of the left-tail critical value Chi-squared(1-alpha) of the chi-squared distribution always (1-alpha), and is the area to the left of this critical value always alpha? Does this apply to all chi-squared distributions?Please see image attachedarrow_forwardSet up a free RStudio account at posit.cloud. At the start of your R session, you should enter the following commands. set.seed(1) e<-rnorm(n = 100,mean = 0,sd = 80) x<-seq(1,100,1) y<-10+15*x + e Follow the examples in the Panopto Videos to use R to obtain the values requested below. (As always, if you round your answers, make sure you do so correctly and keep at least three decimal places.) (a) The smallest value of y = (b) The largest value of y = (c) The standard deviation of y = (d) The mean of y = (e) The median of y = (f) The correlation between x and y = : (g) Using the variable e as data, the p-value for a test of Hoμ = 0 vs. HA μ0 isarrow_forwardDoes Chi-squared(alpha) always represent the right tail of the the chi-square distribution and does Chi-squared(1-alpha) always represent the left tail of the the chi-square distribution. Also, for a standard normal distribution would Z(1-alpha) be equivalent to -Zalpha in represneting the left tail of the standard normal distribution curve because they both have the same z-score. Furthermore, is my understanding correct in the sense that if we have a critical value,say Zalpha, would the area to the right of it will be alpha and to the left of it would be 1-alphaarrow_forward
- One bulb manufacturer claims an average bulb life of 1,600 hours. It is suspected that the actual average is significantly lower. To verify this, a sample of 49 bulbs is selected and the life of each bulb is measured. A sample mean of 1,500 hours and a standard deviation of 120 hours were obtained from them. Can you be sure, at 5% significance, that the mean life is less than what the manufacturer claims?arrow_forwardThe specification calls for the dimension of a certain mechanical part to be 0.55 inches. A random sample of 35 parts taken from a large batch showed a mean 0.54 in. with a deviation of 0.05 in. Can it be concluded, at 1% significance, that the batch of parts meets the required specification?arrow_forwardA manufacturer produces a wire rope of a certain type, which has a breaking strength of not more than 300 kg. A new and cheaper process is discovered which is desired to be employed, provided that the wire rope thus produced has an average breaking strength greater than 300 kg. If a random sample of 26 wires produced with the new process has given a mean of 304.5 kg and a standard deviation of 15 kg, should the manufacturer adopt the new process?arrow_forward
- We are interested in whether the proportions of female suicide victims for ages 15 to 24 are the same between the white and the black races in the United States. We randomly pick one year to compare the races. The number of suicides estimated in the United States in that year for white females is 4,930. Five hundred eighty-three were aged 15 to 24. The estimate for black females is 330. Forty-one were aged 15 to 24. We will let female suicide victims be our population. (Use α = 0.05.) NOTE: If you are using a Student's t-distribution for the problem, including for paired data, you may assume that the underlying population is normally distributed. (In general, you must first prove that assumption, though.) Part (a) State the null hypothesis. ○ Ho: PW> PB O Ho: PW + PB Ho: Pw≤ PB Ho: PW-PB ○ Ho: Pw PB Part (c) In words, state what your random variable P'w-P'B represents. P'w-P'B represents the average difference of white and black female suicide victims, aged 15 to 24. ○ P'w-P'B…arrow_forwardplease solve this problem step by step and make it quick pleasearrow_forwardplease solve this problem step by step and make it quick pleasearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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