Question
In: Statistics and Probability
****Using excel*** A business manager wanted to know if there was a relationship between daily temperature...
****Using excel***
A business manager wanted to know if there was a relationship between daily temperature measured in degrees Fahrenheit and number of employees who called-in sick each day. He collected the following data over 10 days: Daily Temperature: 54 70 67 57 54 63 72 72 54 71 # Called-in Sick: 33 32 30 37 34 28 31 27 31 26
a. Using excel Find the value of the correlation coefficient (r) for Daily Temperature and # Called-in Sick.
b. What does the null hypothesis expect for the problem described. (Be sure to use the variables given in the problem.)
c. Using excel Conduct a statistical test of the null hypothesis using p = .05. Be sure to properly state your statistical conclusion.
d. Provide an interpretation of your statistical conclusion given in part C.
e. What is the value of the coefficient of determination?
f. Provide an interpretation of your answer to Part E.
***Using excel***
Solutions
orchestra answered 1 year agoRelated Solutions
***Using excel to solve the below*** A business manager wanted to know if there was a...
***Using excel to solve the below***
A business manager wanted to know if there was a relationship
between daily temperature measured in degrees Fahrenheit and number
of employees who called-in sick each day. He collected the
following data over 10 days: Daily Temperature: 54 70 67 57 54 63
72 72 54 71 # Called-in Sick: 33 32 30 37 34 28 31 27 31 26 1.
A. Obtain the mode, median, and mean for Daily Temperature
only.
B. Obtain...
Question 2 In a study of the relationship between X = mean daily temperature for the...
Question 2
In a study of the relationship between X = mean daily
temperature for the month and Y = monthly charges on the electrical
bill the following data was gathered:
Temperature (oF): Xi
16
28
13
22
25
19
Number of Calls: Yi
95
120
70
115
130
85
We are interested in fitting the
following simple linear regression model: Y = Xβ +
ε
a) Calculate
X′X, (X′X)-1 and
X′Y and then calculate the least squares estimates
of...
The Pepsi Corporation wants to explore the relationship between the daily temperature in California and the...
The Pepsi Corporation wants to explore the relationship between
the daily temperature in California and the quantity of soft drinks
that it sells at Dadger’s Baseball Stadium. The average daily
temperature for 12 randomly selected days and the quantity of soft
drinks sold on each of these days are given below:
Average Daily Temperature
70
75
80
90
93
98
72
75
75
80
90
95
Quantity Sold (thousands)
30
28
40
52
57
54
27
38
32
46
49...
Curious AP Statistics students wanted to know if there was a relationship between dress code violations...
Curious AP Statistics students wanted to know if there was a
relationship between dress code violations and disciplinary
actions: did students who violated the dress code receive more
suspensions, detention, and work detail. In a blind survey, so the
identities of the subjects were unknown to the AP students, the AP
Statistics students randomly selected 185 students and were given
the results of their survey from school administration regarding
dress code violations and disciplinary actions. The results are
below:
Dress...
In studying the relationship between average daily temperature and time spent on a telephone, suppose you...
In studying the relationship between average daily
temperature and time spent on a telephone, suppose you
computed r=0.607 using n=31 data points. Using
the critical values table below, determine if the value
of r is significant or not.
Homer is studying the relationship between the average daily temperature and time spent watching television and...
Homer is studying the relationship between the average daily
temperature and time spent watching television and has collected
the data shown in the table. The line of best fit for the data is
yˆ=−0.6x+94.5. Assume the line of best fit is
significant and there is a strong linear relationship between the
variables.
Temperature (Degrees) 40506070 Minutes
Watching Television 70655952
(a) According to the line of best fit, what would be the
predicted number of minutes spent watching television for an...
(Use Excel) The quality manager believes there may be a relationship between the experience level of...
(Use Excel) The quality manager believes there may be a
relationship between the experience level of an inspector and
whether a product passes or fails inspection. Inspection records
were reviewed for 628 units of a particular product, and the number
of units which passed and failed inspection was determined based on
three inspector experience levels. The results are shown in the
following table. Decision Experience Level Low (under 2 years)
Medium (2-8 years) High (over 8 years) Pass 152 286...
The concession manager for the Jacksonville Suns has hired you to analyze the relationship between temperature...
The concession manager for the Jacksonville Suns has hired you
to analyze the relationship between temperature (in degrees
Fahrenheit) and beer sales (in 1000's of dollars) for the baseball
games. A sample of 10 games/observations can be found in Mod8-1Data
(Links to an external site.). Run the regression in Minitab and
create the scatter plot with regression line.
Temperature
Beers1000
80
20.533
68
1.439
78
13.829
79
21.286
87
30.985
74
17.187
86
30.24
92
37.596
77
9.61
84
28.742...
A basketball coach wanted to see if there was a relationship between a team and their...
A basketball coach wanted to see if there was a relationship
between a team and their training methods. 50 players were asked
"Do you think practicing 5 times per week will help you win more
games?" Below are each teams responses.
Null hypothesis: A team and their training methods are
independent.
Alternative hypothesis: A team and their training methods are
dependent.
Perform hypothesis testing using the Chi-Square Test for
Independence and interpret the results.
Team
Strongly Agree
Agree
Neutral
Disagree...
A research wanted to see if there was a relationship between the median income for a...
A research wanted to see if there was a relationship between the
median income for a city and how many IT companies are in the
city.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Read the case study and answer the questions When many people think of a traditional, established...
- 4. What is a stranded asset? Provide an example of a stranded asset and be prepared...
- Owners and managers have cited three reasons for the creation of large financial firms or universal...
- Explain the following constitutional ideas. 1. The Pardon Power 2. Ennumerated Power 3. Impeachment and Conviction...
- Your project to obtain charitable donations is now 38 days into a planned 48-day project. The...
- The first financial instrument was a loan. On January 1, the company borrowed 5million on a...
- . Bill builds benches in a small shop and he plans to operate five 8-hour days...
ADVERTISEMENT