Question
In: Statistics and Probability
The director of special events for Sun City believed that the amount of money spent on...
The director of special events for Sun City believed that the amount of money spent on fireworks displays on the 4th of July was predictive of attendance at the Fall Festival held in October. She gathered the following data to test her suspicion.
| 4th of July ($000) | Fall Festival (000) | 4th of July ($000) | Fall Festival (000) | ||||
| 12.6 | 10.2 | 9.0 | 9.5 | ||||
| 8.5 | 6.4 | 12.8 | 12.7 | ||||
| 10.2 | 11.7 | 7.5 | 6.6 | ||||
| 9.0 | 10.2 | 10.0 | 10.1 | ||||
| 5.5 | 6.0 | 6.0 | 6.1 | ||||
| 12.0 | 11.1 | 11.4 | 9.0 | ||||
| 8.0 | 7.5 | 10.4 | 10.8 | ||||
| 7.5 | 8.4 | ||||||
Determine the regression equation. (Round your answers to 3 decimal places.)
Fall = ________ + __________ July
Complete the given table. (Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient, p-value to 3 decimal places and t to 2 decimal places.)
| Predictor | Coefficient | SE Coefficient | t | p-value |
|
Constant |
||||
| July |
Complete the ANOVA table. (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MS, p-value to 3 decimal places and F to 2 decimal places.)
| Source | DF | SS | MS | F | p-value |
| Regression | |||||
| Residual Error | |||||
| Total |
Is the amount spent on fireworks related to attendance at the Fall Festival?
There is ____________ between attendance at the Fall Festival and the fireworks. (a substantial connection) (no substantial connection)
Solutions
Expert Solution
Using Toolpak data analysis in Excel:
First enter data:
Steps: Data-->Data Analysis
Select Fall data in Input Y Range and July in Input X Range.
Tick the lables becuase we selecting data with variable name and then click to OK.
Output:
Determine the regression equation. (Round your answers to 3 decimal places.)
Fall = 1.562 + 0.804 July
Complete the given table. (Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient, p-value to 3 decimal places and t to 2 decimal places.)
| Predictor | Coefficient | SE Coefficient | t | P-value |
| Constant | 1.562 | 1.377 | 1.13 | 0.277 |
| July | 0.804 | 0.143 | 5.61 | 0.000 |
Complete the ANOVA table. (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MS, p-value to 3 decimal places and F to 2 decimal places.)
| Source | DF | SS | MS | F | P-value |
| Regression | 1 | 46.282 | 46.282 | 31.48 | 0.000 |
| Residual Error | 13 | 19.115 | 1.470 | 0 | 0 |
| Total | 14 | 65.397 | 0 | 0 | 0 |
There is a substantial connection between attendance at the Fall
Festival and the fireworks.
orchestra answered 1 year agoRelated Solutions
The director of special events for Sun City believed that the amount of money spent on...
The director of special events for Sun City believed that the
amount of money spent on fireworks displays on the 4th of July was
predictive of attendance at the Fall Festival held in October. She
gathered the following data to test her suspicion.
4th of July ($000)
Fall Festival (000)
4th of July ($000)
Fall Festival (000)
10.9
9.7
9.0
9.5
8.5
6.4
10.5
9.7
12.1
12.3
7.5
6.6
9.0
10.2
10.0
10.1
5.5
6.0
6.0
6.1
12.0
11.1
12.4...
The director of special events for Sun City believed that the amount of money spent on...
The director of special events for Sun City believed that the
amount of money spent on fireworks displays on the 4th of July was
predictive of attendance at the Fall Festival held in October. She
gathered the following data to test her suspicion.
4th of July ($000)
Fall Festival (000)
4th of July ($000)
Fall Festival (000)
10.9
9.7
9.0
9.5
8.5
6.4
10.5
9.7
12.1
12.3
7.5
6.6
9.0
10.2
10.0
10.1
5.5
6.0
6.0
6.1
12.0
11.1
12.4...
It is believed that the average amount of money spent per U.S. household per week on...
It is believed that the average amount of money spent per U.S.
household per week on food is about $98, with standard deviation
$10. A random sample of 100 households in a certain affluent
community yields a mean weekly food budget of $100. We want to test
the hypothesis that the mean weekly food budget for all households
in this community is higher than the national average. Are the
results significant at the 5% level?
a) No, we should fail...
The distribution of the amount of money spent by students on textbooks in a semester is...
The distribution of the amount of money spent by students on
textbooks in a semester is approximately normal in shape with a
mean of 349 and a standard deviation of 24. According to the
standard deviation rule, approximately 95% of the students spent
between _____$ and _____$ on textbooks in a semester.
Question 12
Type numbers in the boxes.
1 points
The distribution of IQ (Intelligence Quotient) is approximately
normal in shape with a mean of 100 and a standard...
The distribution of the amount of money spent by students on textbooks in a semester is...
The distribution of the amount of money spent by students on
textbooks in a semester is approximately normal in shape with a
mean of 349 and a standard deviation of 24. According to the
standard deviation rule, approximately 95% of the students spent
between ____$ and ____$ on textbooks in a semester.
Question 12
Type numbers in the boxes.
1 points
The distribution of IQ (Intelligence Quotient) is approximately
normal in shape with a mean of 100 and a standard...
A study was conducted to compare males and females and the amount of money spent on...
A study was conducted to compare males and females and the
amount of money spent on a particular mobile phone app. Data for a
large random sample of males (n>1000) and a large random sample
of females (n>1000) were extracted. What type of analysis will
best allow us to determine if the average amount of money spent on
the particular mobile phone app is greater for males than for
females?
options:
An independent samples comparison of population means.
A paired...
Question 10: The distribution of the amount of money spent by students on textbooks in a...
Question 10:
The distribution of the amount of money spent by students on
textbooks in a semester is approximately normal in shape with a
mean of 494 and a standard deviation of 39.
According to the standard deviation rule, approximately
68% of the students spent between $_____ and $ ______ on textbooks
in a semester.
Question 11:
The distribution of IQ (Intelligence Quotient) is approximately
normal in shape with a mean of 100 and a standard deviation of
16.
According...
Predicting the Amount of Money Spent on Insured Customers For this assignment, we will be analyzing...
Predicting the Amount of Money Spent on Insured Customers
For this assignment, we will be analyzing insured customers'
data for an insurance company:
Based on a
sample data that consists of the profile of insured customers, we
want to be able to predict the dollar amount of money spent by the
insurance company on insured customers.
Insured ustomers' Data
The insured customers'
data is in a csv file. It has information sconsisting of:
1.age
2.sex (female, male)
3.BMI
4.Children
5.Smoker...
The amount of money spent weekly on cleaning, maintenance, and repairs at a large restaurant was...
The amount of money spent weekly on cleaning, maintenance, and
repairs at a large restaurant was observed over a long period of
time to be approximately normally distributed, with mean μ
= $601 and standard deviation σ = $45.
(a) If $646 is budgeted for next week, what is the probability
that the actual costs will exceed the budgeted amount? (Round your
answer to four decimal places.)
(b) How much should be budgeted for weekly repairs, cleaning, and
maintenance so...
1) The distribution of the amount of money spent by college students for school supplies in...
1) The distribution of the amount of money spent by college
students for school supplies in a semester is normally distributed
with a mean of $275 and a standard deviation of $20.
Using the Standard Deviation Rule, there is a 99.7%
probability that students spent between:
Group of answer choices
$255 and $295
$215 and $315
$235 and $315
$235 and $335
$215 and $335
2) The distribution of the amount of money spent by college
students for school supplies...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Data governance programs focus on different areas based on organizational needs. Trinity Hospital has chosen to...
- You have decided to place $920 in equal deposits every month at the beginning of the...
- what was the second industrial revolution and how is tied to the rise of big business...
- In this assignment, students are required to write a report and do a presentation on a...
- The interest rate paid on funds deposited in a bank is determined by the amount of...
- Discussion 5 - Controversy 5: Is Butter Really Back? The Lipid Guidelines Debate Using the information...
- Myers Briggs Personality Assessment 1. According to the Personality Inventory, what is your personality type? 2....
ADVERTISEMENT