D1 Time(Mins) 1.) A survey was taken among college students as to how many minutes they play a newly released online game Genshin Impact per day. Using UNGROUPED statistical analysis, calculate the followig: a.) Mean, Median and Mode, b.) Varriance and Standard Deviation. (Attach the photograph of your MANUALLY WRITTEN solution in the space provided) 244 195 270 180 188 175 251 206 194 180 315 2.) Perform GROUPED data statistical analysis using EXCEL with 11 class intervals on the same data set for the previous number and calculate the following a.) Mean, Median and Mode, b.) Varriance and Standard Deviation. (Attach the EXCEL SPREADSHEET in the 262 239 304 180 space provided) 294 204 254 316 312
D1 Time(Mins) 1.) A survey was taken among college students as to how many minutes they play a newly released online game Genshin Impact per day. Using UNGROUPED statistical analysis, calculate the followig: a.) Mean, Median and Mode, b.) Varriance and Standard Deviation. (Attach the photograph of your MANUALLY WRITTEN solution in the space provided) 244 195 270 180 188 175 251 206 194 180 315 2.) Perform GROUPED data statistical analysis using EXCEL with 11 class intervals on the same data set for the previous number and calculate the following a.) Mean, Median and Mode, b.) Varriance and Standard Deviation. (Attach the EXCEL SPREADSHEET in the 262 239 304 180 space provided) 294 204 254 316 312
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
Transcribed Image Text:AutoSave
FORMATIVE ASSESSMENT 4 DATA (2) - Protected View -
P Search (Alt+Q)
Off
James M. Grejaldo
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
P Comments
A Share
) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
:X v fx
S18
A
B
D
E
G H
K
L
M
P
Q
R
S
U
V
w
X Y
AA
АВ
AC
AD
1
D1
2 Time(Mins)
1.) A survey was taken among college students as to how many
3.) You also want to know if there is a relationship between the
3
244
minutes they play a newly released online game Genshin Impact
number of days the college students have been playing the online
per day. Using UNGROUPED statistical analysis, calculate the
followig: a.) Mean, Median and Mode, b.) Varriance and Standard
4
195
game and how much money they spent for it on average. Using
5
270
simple linear regression in EXCEL, a.) Calculate for the regression
6
180
Deviation. (Attach the photograph of your MANUALLY WRITTEN
line, b.) Predict the next 3 data points and make a preliminary
7
188
solution in the space provided)
conclusion for the trend you are observing lastly, c.) Make a scatter
8
175
plot of the data with the regression line.
9
251
10
206
11
194
12
180
Days
Pesos 1
2.) Perform GROUPED data statistical analysis using EXCEL with 11
class intervals on the same data set for the previous number and
13
315
2
249
14
262
4
749
15
239
calculate the following a.) Mean, Median and Mode, b.) Varriance
1490
16
304
and Standard Deviation. (Attach the EXCEL SPREADSHEET in the
8
2490
17
180
space provided)
10
2488
18
294
12
3980
19
204
14
5490
20
254
16
4978
21
316
18
6468
22
312
20
4978
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
DATA SET 1
Ready
100%
O Type here to search
27°C Partly cloudy
2:08 pm
26/01/2022
X
A T 4)
O a D ENG
出
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
