APPLIED STAT.IN BUS.+ECONOMICS
6th Edition
ISBN: 9781259957598
Author: DOANE
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12.4, Problem 18SE
Instructions for exercises 12.18 and 12.19: (a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy (the same worksheet you used in exercises 12.2 and 12.3). (b) Use the formulas to calculate the slope and intercept. (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (d) Use these sums to calculate the R2. (e) To check your answers, make an Excel
12.18
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Write codes to perform the functions in each of these cases
i.
ii.
Apply cd command to tell STATA the filepath associated with
your "favorite folder" (use the same name for the favorite folder
that we have been using in class)
Apply log using command to tell stata that you are creating a log
file to record the codes and the outcomes of these codes. Make
sure your log file is called loghwa1_W25.smcl. Do not forget to
include the replace option.
iii. Get help for the "regress" command & include a screenshot of
the outcome of this code
iv.
V.
Open a stata file stored in STATA memory called pop2000.dta
Continue from question iv. Save this file in your favorite folder
(current working directory) using a different name & a replace
option
Are there any unusually high or low pH levels in this sample of wells?
0
n
AM
RIES
s of
of
10
m
Frequency
40
Frequency
20
20
30
10
You make two histograms from two different
data sets (see the following figures), each
one containing 200 observations. Which of
the histograms has a smaller spread: the first
or the second?
40
30
20
10
0
20
40
60
0
20
20
40
60
60
80
80
100
80
100
Chapter 12 Solutions
APPLIED STAT.IN BUS.+ECONOMICS
Ch. 12.1 - For each sample, do a test for zero correlation....Ch. 12.1 - Instructions for Exercises 12.2 and 12.3: (a) Make...Ch. 12.1 - Prob. 3SECh. 12.1 - Prob. 4SECh. 12.1 - Instructions for exercises 12.412.6: (a) Make a...Ch. 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 - Instructions for exercises 12.23 and 12.24: (a)...Ch. 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 - Below is a regression using X = home price (000),...Ch. 12.6 - Below is a regression using X = average price, Y =...Ch. 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 - Calculate the standardized residual ei and...Ch. 12.9 - Prob. 37SECh. 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. 40SECh. 12.9 - Prob. 41SECh. 12.9 - Prob. 42SECh. 12.9 - Prob. 43SECh. 12.11 - Prob. 44SECh. 12.11 - Prob. 45SECh. 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 - (a) When is logistic regression needed? (b) Why...Ch. 12 - Prob. 46CECh. 12 - Prob. 47CECh. 12 - Prob. 48CECh. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Prob. 50CECh. 12 - Prob. 51CECh. 12 - Prob. 52CECh. 12 - Prob. 53CECh. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Prob. 57CECh. 12 - Prob. 58CECh. 12 - Prob. 59CECh. 12 - Prob. 60CECh. 12 - Prob. 61CECh. 12 - Prob. 62CECh. 12 - Prob. 63CECh. 12 - Prob. 64CECh. 12 - Prob. 65CECh. 12 - In the following regression, X = weekly pay, Y =...Ch. 12 - Prob. 67CECh. 12 - In the following regression, X = total assets (...Ch. 12 - Prob. 69CECh. 12 - Below are percentages for annual sales growth and...Ch. 12 - Prob. 71CECh. 12 - Prob. 72CECh. 12 - Prob. 73CECh. 12 - Simple regression was employed to establish the...Ch. 12 - Prob. 75CECh. 12 - Prob. 76CECh. 12 - Prob. 77CECh. 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...Ch. 12 - Prob. 81CE
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
- TIP the aren't, the data are not sym 11 Suppose that the average salary at a certain company is $100,000, and the median salary is $40,000. a. What do these figures tell you about the shape of the histogram of salaries at this company? b. Which measure of center is more appro- priate here? c. Suppose that the company goes through a salary negotiation. How can people on each side use these summary statistics to their advantage? 6360 be 52 PART 1 Getting Off to a Statistically Significant Sarrow_forward12 Suppose that you know that a data set is skewed left, and you know that the two measures of center are 19 and 38. Which figure is the mean and which is the median?arrow_forwardy of 45 home- televisions u find that 010020 le own one, ee, and 1 owns y histogram of 4 Suppose that you have a loaded die. You roll it several times and record the outcomes, which are shown in the following figure. Histogram for Loaded Die 444% 34.00 48% 6% 2% Frequency 20 20 15 155 10 5- ம 0 1 2 3 4 Outcome 5 6 a. Make a relative frequency histogram of these results. b. You can make a relative frequency histo- gram from a frequency histogram; can you go the other direction?arrow_forward
- Calculate the mean for Study Hours and Test Scores. Compute the covariance between the two variables using the formula: Calculate the standard deviation for Study Hours (X) and Test Scores (Y). Determine the correlation coefficient Interpret the results: What does the calculated r-value indicate about the relationship between study hours and test scores?arrow_forwardFor unemployed persons in the United States, the average number of months of unemployment at the end of December 2009 was approximately seven months (Bureau of Labor Statistics, January 2010). Suppose the following data are for a particular region in upstate New York. The values in the first column show the number of months unemployed and the values in the second column show the corresponding number of unemployed persons. Months Unemployed Number Unemployed 1 1029 2 1686 3 2269 4 2675 5 3487 6 4652 7 4145 8 3587 9 2325 10 1120 Let x be a random variable indicating the number of months a person is unemployed. a. Use the data to develop an empirical discrete probability distribution for x (to 4 decimals). (x) f(x) 1 2 3 4 5 6 7 8 9 10 b. Show that your probability distribution satisfies the conditions for a valid discrete probability distribution. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank c. What is the probability that a…arrow_forwardWest Virginia has one of the highest divorce rates in the nation, with an annual rate of approximately 5 divorces per 1000 people (Centers for Disease Control and Prevention website, January 12, 2012). The Marital Counseling Center, Inc. (MCC) thinks that the high divorce rate in the state may require them to hire additional staff. Working with a consultant, the management of MCC has developed the following probability distribution for x = the number of new clients for marriage counseling for the next year. Excel File: data05-19.xls x 10 f(x) .05 20 30 .10 .10 40 .20 50 60 .35 .20 a. Is this probability distribution valid? - Select your answer- Explain. f(x) Σf(x) Select your answer Select your answer b. What is the probability MCC will obtain more than 30 new clients (to 2 decimals)? c. What is the probability MCC will obtain fewer than 20 new clients (to 2 decimals)? d. Compute the expected value and variance of x. Expected value Variance clients per year squared clients per yeararrow_forward
- For unemployed persons in the United States, the average number of months of unemployment at the end of December 2009 was approximately seven months (Bureau of Labor Statistics, January 2010). Suppose the following data are for a particular region in upstate New York. The values in the first column show the number of months unemployed and the values in the second column show the corresponding number of unemployed persons. Months Unemployed Number Unemployed 1 1029 2 1686 3 2269 4 2675 5 3487 6 4652 7 4145 8 3587 9 2325 10 1120 Let x be a random variable indicating the number of months a person is unemployed. a. Use the data to develop an empirical discrete probability distribution for x (to 4 decimals). (x) f(x) 1 2 3 4 5 6 7 8 9 10 b. Show that your probability distribution satisfies the conditions for a valid discrete probability distribution. The input in the box below will not be graded, but may be reviewed and considered by your instructor. c. What is the probability that a person…arrow_forwardIn Gallup's Annual Consumption Habits Poll, telephone interviews were conducted for a random sample of 1014 adults aged 18 and over. One of the questions was "How many cups of coffee, if any, do you drink on an average day?" The following table shows the results obtained (Gallup website, August 6, 2012). Excel File: data05-23.xls Number of Cups per Day Number of Responses 0 365 264 193 3 4 or more 91 101 Define a random variable x = number of cups of coffee consumed on an average day. Let x = 4 represent four or more cups. Round your answers to four decimal places. a. Develop a probability distribution for x. x 0 1 2 3 4 f(x) b. Compute the expected value of x. cups of coffee c. Compute the variance of x. cups of coffee squared d. Suppose we are only interested in adults that drink at least one cup of coffee on an average day. For this group, let y = the number of cups of coffee consumed on an average day. Compute the expected value of y. Compare it to the expected value of x. The…arrow_forwardIn Gallup's Annual Consumption Habits Poll, telephone interviews were conducted for a random sample of 1014 adults aged 18 and over. One of the questions was "How many cups of coffee, if any, do you drink on an average day?" The following table shows the results obtained (Gallup website, August 6, 2012). Excel File: data05-23.xls Number of Cups per Day Number of Responses 0 365 264 193 2 3 4 or more 91 101 Define a random variable x = number of cups of coffee consumed on an average day. Let x = 4 represent four or more cups. Round your answers to four decimal places. a. Develop a probability distribution for x. x 0 1 2 3 f(x) b. Compute the expected value of x. cups of coffee c. Compute the variance of x. cups of coffee squared d. Suppose we are only interested in adults that drink at least one cup of coffee on an average day. For this group, let y = the number of cups of coffee consumed on an average day. Compute the expected value of y. Compare it to the expected value of x. The…arrow_forward
- A technician services mailing machines at companies in the Phoenix area. Depending on the type of malfunction, the service call can take 1, 2, 3, or 4 hours. The different types of malfunctions occur at about the same frequency. Develop a probability distribution for the duration of a service call. Duration of Call x f(x) 1 2 3 4 Which of the following probability distribution graphs accurately represents the data set? Consider the required conditions for a discrete probability function, shown below.Does this probability distribution satisfy equation (5.1)?Does this probability distribution satisfy equation (5.2)? What is the probability a service call will take three hours? A service call has just come in, but the type of malfunction is unknown. It is 3:00 P.M. and service technicians usually get off at 5:00 P.M. What is the probability the service technician will have to work overtime to fix the machine today?arrow_forwardA psychologist determined that the number of sessions required to obtain the trust of a new patient is either 1, 2, or 3. Let x be a random variable indicating the number of sessions required to gain the patient's trust. The following probability function has been proposed. x f(x) for x = 1, 2, or 3 a. Consider the required conditions for a discrete probability function, shown below. f(x) ≥0 Σf(x) = 1 (5.1) (5.2) Does this probability distribution satisfy equation (5.1)? Select Does this probability distribution satisfy equation (5.2)? Select b. What is the probability that it takes exactly 2 sessions to gain the patient's trust (to 3 decimals)? c. What is the probability that it takes at least 2 sessions to gain the patient's trust (to 3 decimals)?arrow_forwardA technician services mailing machines at companies in the Phoenix area. Depending on the type of malfunction, the service call can take 1, 2, 3, or 4 hours. The different types of malfunctions occur at about the same frequency. Develop a probability distribution for the duration of a service call. Which of the following probability distribution graphs accurately represents the data set? Consider the required conditions for a discrete probability function, shown below.Does this probability distribution satisfy equation (5.1)?Does this probability distribution satisfy equation (5.2)? What is the probability a service call will take three hours? A service call has just come in, but the type of malfunction is unknown. It is 3:00 P.M. and service technicians usually get off at 5:00 P.M. What is the probability the service technician will have to work overtime to fix the machine today?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
What is a Linear Equation in One Variable?; Author: Don't Memorise;https://www.youtube.com/watch?v=lDOYdBgtnjY;License: Standard YouTube License, CC-BY
Linear Equation | Solving Linear Equations | What is Linear Equation in one variable ?; Author: Najam Academy;https://www.youtube.com/watch?v=tHm3X_Ta_iE;License: Standard YouTube License, CC-BY