ESI 3215 PROJECT
docx
keyboard_arrow_up
School
Florida International University *
*We aren’t endorsed by this school
Course
3215
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
5
Uploaded by SargentWhaleMaster161
ESI 3215
Course Project
\
DATA ANALYSIS
In order to take the simple random samples for tasks 1 and 2 the =rand() function in Excel was used to assign a random value to each row and sort by the random number assigned. From there 10 sets of 5 random samples were selected. The process was repeated to select the 10 sets of 31 random samples.
Task 1: 10 SRS of Size 5:
For this task, the sample mean distribution was 174.24. According to the probability plot, there is a moderate correlation between the means of the samples.
Samples
1
2
3
4
5
6
7
8
9
10
Means
15.40
74.60
67.00
45.60
41.80
25.40
272.60
720.80
21.40
457.75
Task 2: 10 SRS of Size 31:
For this task, the sample mean distribution was 125.21. According to the probability plot, there is a strong correlation between the means of the samples.
Samples
1
2
3
4
5
6
7
8
9
10
Means
249.97
72.50
52.67
46.00
219.70
141.10
28.77
158.75
234.29
48.35
Task 3: 1 SRS of size 50:
The population mean was not within the 95% CI that was calculated.
Mean
225.49
Standard Deviation
535.15
Sample Size = n
50
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
95
% CI
=
225.49
−
1.96
(
535.15
)
√
50
=−
116.45
95
% CI
=
225.49
+
1.96
(
535.15
)
√
50
=
180.22
RequiredCI is
−
116.45
<
μ
<
180.22
Task 4: Bar Chart of Total # of Covid Cases for Each State
On the X Axis are the States and on the Y are the number of covid cases.
Task 5:
Here are the 10 colleges I picked.
The strong positive correlation, indicated by a correlation coefficient of 0.855, suggests a significant relationship between the number of cases and the student population.
A positive correlation exists between the reported number of COVID-19 cases in a college and its student population. This connection is likely influenced by various factors, such as the heightened risk of transmission in densely populated environments, the presence of on-campus housing facilitating rapid spread, and the involvement of larger colleges in athletic teams and extracurricular activities, further amplifying the potential for transmission. In summary, the larger the student population, the higher the likelihood of increased COVID-19 cases, attributed to the dynamics of close interactions, on-campus living, and shared activities.