Week 4 Excel-HOANG KIM TO
xlsx
keyboard_arrow_up
School
Webster University *
*We aren’t endorsed by this school
Course
5020
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
xlsx
Pages
7
Uploaded by DeanPencilCobra27
Name:
ID:
4234529
30
28
50
25
40
25
55
23
30
30
25
32
60
21
1) Which vaiable is the dependent variable? MPG
25
35
2) Which variable is the independent variable?
Speed
50
26
55
25
3) Construct a scatter diagram with dependent variable on the vertical axis (Y)
and the independent variable on the horizontal axis (x)
Please label the chart and the axies. 4) What does the plot show about the relationship between the two variables?
If yes, positive or negative? Weak or strong?
5) Compute the correlation of coeffient of the two variables
-0.91036937926
6) What can you say about the linear relationship of the two variables based
on the correlation coefficient?
Speed (Miles/Hour)
MPG (Miles/Gallon)
HOANG KIM TO A study on driving speed (miles per hour) and fuel efficiency (MPG: miles per gallon) for midsize automobiles resulted in the data listed.
The two variables has a weaker negative linear relationship The two variables has a weaker negative linear relationship 20
25
30
35
40
45
50
55
60
65
0
5
10
15
20
25
30
35
40
f(x) = − 0.286144578313253 x + 39.0180722891566
Scatter Plot of Driving Speed vs. Fuel Efficiency for Midsize Automobiles
Speed (Miles/Hour)
MPG (Miles/Gallon)
End of this worksheet. Move to the next worksheet.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Speed
MPG
1) What is the probability that a randomly selected person in the US is 65 or older?
p(A)=
15.8%
2) What is the probability that a randomly selected person in the US is under 65 years old?
p(NA)=
84.2%
3) For a random selected person 65 or older, what is the probability that this person is uninsured?
p(U |A )=
1.1% (This is given in the problem description)
4) For a random selected person under 65, what is the probability that this person is uninsured?
p( U|NA)=
17.5% (You can figure this out using the info given in the problem discription)
This group includes under 18 and 18 to 64
5) Given that the person in the US is uninsured, what is the probability that the person is 65 or older?
p(A| U)=
1.94%
0.019419
(hint: Use Baye's Theorem)
End of this worksheet. Move to the next tab.
The National Center for Health Statistics, housed within the US. Centers for Disease Control and Prevention (CDC), tracks the number in the US who have health insurance. According to this agency, the uninsured rates for people in the US in 2018 are as follows: 5.1% of those under the age of 18, 12.4% of those ages 18-64, and 1.1% of those 65 and older do not have health insurance (CDC website).
Approximately 22.8% of Americans are under age 18, and 61.4% are ages 18 to 64.
Let
A
= American age 65 or older
NA=American under age 65
U = uninsured
S&P 500's Annual Performance
First week
Higher
Lower
Total
First week
Higher
37
5
42
Higher
Lower
11
11
22
Lower
Total
48
16
64
Total
a) If a year is selected at random,
what is the probability that the S&P 500 finished lower for the year?
25%
b) Given that the S&P fiished lower after the first five days of trading,
what is the proability that it finished lower for the year?
50%
c) Are the two events "first week performance" and "annual performance"
independent?
Dependent End of this assignment.
(there are three tabs in this assignment)
In 42 of the 64 years from 1950 through 2014,the S& P 500 finished higher after the first five days of trading (in 2011 there was virtually no change). In 37 out of 42 years, the S&P 500 finished higher for the year. Is a good first week a good omen for the upcoming year? The following table gives the first-week and annual performance over this 64-year period. A: S&P 500 finished higher after the first five days of trading. B: S&P 500 finished higher for the year.P(A)= 42/64 = 0.65625 P(B) = 48/64 = 0.75
P(A and B) = 37/64
To determine if the events are independent, compare P(A and B) with P(A) * P(B):
P(A) * P(B) = 0.65625 * 0.75 = 0.4921875
Since P(A and B) is not equal to P(A) * P(B), the events "first week performance" and "annual performance" are not independent.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Annual Higher
Lower
Total
37
5
42
11
11
22
48
16
64
0.5