Home

first row of questions (please use document below for the data)
1.
2.Based on the above simple regression analysis, how much should the hiring managers expect to have for Newspaper/Magazine in the following January (Month 13)? Round to two decimal places, do not include the dollar sign. 3The hiring managers want to compare three different employment sources: Newspaper/Magazine, CareerBuilder, and Monster.com. Perform simple regressions as you did above predicting allocations for month 13 for those three employment sources. Which of the following statements would be the best conclusion from your analysis?
Group of answer choicesThe model R-square for Monster.com is the highest R-square value of the three platforms. Therefore, management will likely provide the most funding for that platform, and we should focus on that above the other two.The models for Monster.com and Newspaper/Magazine are both significant, which means we should focus on these two platforms over CareerBuilder because management will likely provide us the most funding for those two platforms.
The predicted monthly amount for CareerBuilder is lower than the predicted amount for Newspaper/Magazine. Therefore, they should expect the lowest amount of funding for CareerBuilder out of all of the three, and should concentrate on their efforts on the other two employment resources.
The monthly amounts for Monster.com have a negative slope, compared to the other two, which have a positive slope. Therefore, they should expect lower funding for Monster.com than in the past, and should concentrate their efforts on the other two employment resources.
All of the above are correct.
None of the above are correct.
4For ease of performing the next task, move the variable “Social Networks – Facebook, Twitter, etc” to column A on the spreadsheet. (i.e. Make sure it is the first column in the spreadsheet.)
The hiring managers recognize that the funding for one employment source depends on the funding for the other sources. Therefore, they want you to perform a multiple regression predicting Social Network funding from Months 1-12, while controlling for the funding of Billboard, Careerbuilder, Company Intranet – Partner, and Diversity Job Fair. Assume that we know the funding for the the controlled variables for Month 13. They are: Billboard: 520
Careerbuilder: 800
Company Intranet: 0
Diversity Job Fair: 1000
For this model and these known values, what is the predicted value for Social Network funding for Month 13? 5.Compare the performance of the model above with a model that just controls for the funding of Billboard. In other words, create a multiple regression predicting Social Network funding from Months 1-12, while controlling for the funding of Billboard. Compare the Regression Statistics. Which model does a better job of explaining the variance in Social Network funding? Group of answer choicesThe model that just controls for BillboardThe model that controls for Billboard, Careerbuilder, Company Intranet, and Diversity Job Fair
second row
1
xiyi
13
27
35
411
514
Which of the following is a scatter diagrams accurately represents the data above?
Group of answer choicesNone of the diagramsDiagram 1
Diagram 2
Diagram 3
2Find the slope (b1) for the regression equation for the following values. Round to 3 decimal places. Define Variablesxiyi
33180
25
170
50200
65155
57160
27165
3Try to approximate the relationship between x and y by drawing a straight line through the data. Which of the following is a scatter diagrams accurately represents the data?
Group of answer choicesDiagram 1Diagram 2
Diagram 3
None of the diagrams
4Find the intercept (b0) for the regression equation for the following values. Round to 3 decimal places. Attention: The numbers may be different from the previous question. Interceptxiyi
33180
25
170
50200
65192
57160
27165
5Flight bookings on the Orbitz travel site fluctuate throughout the year. In the month of December, the Orbitz team knows that bookings increase throughout the month. The team is trying to predict number of bookings in a given day throughout the month. They have sampled data from a few dates out of last December and would like to predict the upcoming December bookings. The data are below. In this scenario’s regression equation, x is __________. Orbitz TravelDates in DecemberBookings in the thousands
13
4
7
74
105
136
165
198
2210
2513
2714
3016
Group of answer choicesDate in DecemberDate in January
16 thousand
Bookings in the thousands
6Flight bookings on the Orbitz travel site fluctuate throughout the year. In the month of December, the Orbitz team knows that bookings increase throughout the month. The team is trying to predict number of bookings in a given day throughout the month. They have sampled data from a few dates out of last December and would like to predict the upcoming December bookings. The data are below. Orbitz Travel SiteDates in DecemberBookings in the thousands
13
4
7
74
105
136
165
198
2210
2513
2714
3016
If the intercept for the above data is 1.82 and the slope is 0.41, what is the complete regression equation? Group of answer choicesx = .41y + 1.82y = .41x + 1.82
y = 1.82(.41) + x
y = 1.82x + .41
7A casino is interested in the relationship between the amount of alcohol people buy and the amount of money they spend at the slot machines. They have sampled 10 people and measured the amount of alcohol they drank and how much they spend that day. Based on the regression line, they would like to predict how much money people will spend based on the amount that they drink. The data are below. Alcohol by the OunceOunces purchasedDollars spent on slots
.535
1
64
2100
173
2.5110
3150
1.5130
5300
3130
2.5105
If the regression line is:
y = 50.87x + 7.78, How much money do we predict that a person who drinks 2.94 ounces of alcohol spends? Round to 2 decimal places. Do not put a dollar sign in your answer. 8An apartment management company wants to explore the consequences of allowing residents to have multiple dogs. They would like to find out whether the number of dogs predicts resident ratings. They would also like to control for the year the apartment complex was built because they know that might also affect the resident rating. They have collected data on several of their existing complexes. For each complex, they have counted the number of dogs currently living in the complex, the year the complex was built, and the average rating for that particular complex. They would like to perform a multiple regression on these variables to predict resident ratings. See data below:
Multiple Dog ConsiderationNumber of dogsYear of facilityRating (out of 5)
5419752
31
19643.5
020154.8
1120113.8
7319642.3
2320163.7
020154.7
4919892.7
In this scenario, the y (dependent variable) is: Group of answer choicesRating (out of 5)Number of Dogs
Year of Facility
Number of Residents
9An apartment management company wants to explore the consequences of allowing residents to have multiple dogs. They would like to find out whether the number of dogs predicts resident ratings. They would also like to control for the year the apartment complex was built because thaty might also affect the resident rating. They have collected data on several of their existing complexes. For each complex, they have counted the number of dogs currently living in the complex, the year the complex was built, and the average rating for that particular complex. They would like to perform a multiple regression on these variables to predict resident ratings. See data below. These data are the same as the previous question. Multiple Dog ConsequencesNumber of dogsYear of facilityRating (out of 5)
5419752
31
19643.5
020154.8
1120113.8
7319642.3
2320163.7
020154.7
4919892.7
What is the b coefficient for Number of Dogs? Round to 3 decimal places.
10An apartment management company wants to explore the consequences of allowing residents to have multiple dogs. They would like to find out whether the number of dogs predicts resident ratings. They would also like to control for the year the apartment complex was built because that might also affect the resident rating. They have collected data on several of their existing complexes. For each complex, they have counted the number of dogs currently living in the complex, the year the complex was built, and the average rating for that particular complex. They would like to perform a multiple regression on these variables to predict resident ratings. See data below. These data are the same as the previous question. Consequences of Multiple DogsNumber of dogsYear of facilityRating (out of 5)
5419752
31
19643.5
020154.8
1120113.8
7319642.3
2320163.7
020154.7
4919892.7
What is the p-value for Number of Dogs? Round to 3 decimal places.
11An apartment management company wants to explore the consequences of allowing residents to have multiple dogs. They would like to find out whether the number of dogs predicts resident ratings. They would also like to control for the year the apartment complex was built because thaty might also affect the resident rating. They have collected data on several of their existing complexes. For each complex, they have counted the number of dogs currently living in the complex, the year the complex was built, and the average rating for that particular complex. They would like to perform a multiple regression on these variables to predict resident ratings. See data below. These data are the same as the previous question. Number of Dogs and RatingsNumber of dogsYear of facilityRating (out of 5)
5419752
31
19643.5
020154.8
1120113.8
7319642.3
2320163.7
020154.7
4919892.7
Fill in the blanks using the dropdown menus. The effect of Number of Dogs has a p-value [ Select ] [“more than”, “equal to”, “less than”] .05, which means it is [ Select ] [“significant”, “not significant”] . It is [ Select ] [“likely”, “unlikely”] that the effect of Number of Dogs on Resident Ratings is due to chance (i.e. not a real effect). The effect of Year of Facility has a p-value [ Select ] [“less than”, “equal to”, “more than”] .05, which means it is [ Select ] [“not significant”, “significant”] . It is [ Select ] [“unlikely”, “likely”] that the effect of Year of Facility on Resident Ratings is due to chance (i.e. not a real effect). 12An apartment management company wants to explore the consequences of allowing residents to have multiple dogs. They would like to find out whether the number of dogs predicts resident ratings. They would also like to control for the year the apartment complex was built because that might also affect the resident rating. They have collected data on several of their existing complexes. For each complex, they have counted the number of dogs currently living in the complex, the year the complex was built, and the average rating for that particular complex. They would like to perform a multiple regression on these variables to predict resident ratings. See data below. These data are the same as the previous question. Multiple Dog RatingsNumber of dogsYear of facilityRating (out of 5)
5419752
31
19643.5
020154.8
1120113.8
7319642.3
2320163.7
020154.7
4919892.7
What is the R Square value for this model? Round to 3 decimal places.
13. An apartment management company wants to explore the consequences of allowing residents to have multiple dogs. They would like to find out whether the number of dogs predicts resident ratings. They would also like to control for the year the apartment complex was built because that might also affect the resident rating. They have collected data on several of their existing complexes. For each complex, they have counted the number of dogs currently living in the complex, the year the complex was built, and the average rating for that particular complex. They would like to perform a multiple regression on these variables to predict resident ratings. See data below. These data are the same as the previous question. Positive and Negative Dog RatingsNumber of dogsYear of facilityRating (out of 5)
5419752
31
19643.5
020154.8
1120113.8
7319642.3
2320163.7
020154.7
4919892.7
What can we conclude about this multiple regression analysis? Fill in the blanks.
There is a [ Select ] [“negative”, “positive”] effect of Number of Dogs on Resident Ratings. There is a [ Select ] [“positive”, “negative”] effect of Year of Facility on Resident Ratings. As Number of Dogs increases, Resident Ratings [ Select ] [“decrease”, “stay the same”, “increase”] . Therefore, we recommend that the management [ Select ] [“does not make any changes to dog limits”, “allows more dogs”, “allows fewer dogs”] in their future complexes.