Critical Value: Margin of Error: Lower Bound: Upper Bound: Interpret (context) OEM C *2 decimals *2 decimals Calculation: *2 decimals Calculation: *2 decimals Calculation: bie Online College Studente:

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
100%
The directions are in green on the excel spreadsheet and in the word document. The yellow cells are what I’m having trouble figuring out.
A
B
D
E
G
Note: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failed
assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework.
95% Confidence Interval for Average Age of Online College Students:
2
3 Age
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
33 M
34 M
35 F
20 F
18 F
19 M
45 F
33 M
24 M
37 F
26 M
24
25
26
27
28
Gender
29
30
31
32
33
34
32 F
32 F
18 F
35
16 M
37 F
23 F
4
28 F
77 F
50 F
22 M
25 M
26 F
30 M
25 M
24 M
Week 3
Points
1
2
2
2
1
1
2
1
1
2
2
2
2
1
Sample Mean:
Sample St. Dev:
Sample Size:
1
Distribution:
Critical Value:
Margin of Error:
Lower Bound:
Upper Bound:
Interpret
(context)
Sample Size:
Number of Males:
Male Proportion:
Distribution:
Critical Value:
95% Confidence Interval for Proportion of Male Online College Students:
Margin of Error:
Lower Bound:
Upper Bound:
28.88
12.92
Interpret
2
(context)
Week 5 Week 6 Project Help
*2 decimals
+
*2 decimals Calculation:
*2 decimals Calculation:
*2 decimals Calculation:
Female Proportion
*2 decimals
Note: Calculation cells should
list the numbers and
operations used to get your
answers. Do not put the
generic formula and show all
calculation steps.
4 decimals Calculation:
*4 decimals Calculation:
*4 decimals Calculation:
*4 decimals
Help for this spreadsheet
• Review 8.2 of your text as well as the
Project Help tab below for the first
confidence interval calculation (mean).
Also watch Excel videos in BlackBoard.
• Review 8.3 of your text as well as the
Project Help tab below for the second
confidence interval calculation
.
(proportion). Also watch Excel videos in
BlackBoard.
●
"Show Your Calculation" - these cells
should list the numbers and operations
used to get your answers. Do not just
put the general formula and show all
calculation steps. Do not put "=" in
formulas so I can see the formula by just
looking at the cell, not opening it.
. For the "Interpret" text, what can we
conclude about the population mean
age and the population male proportion
of online students with respect to these
bounds?
• Your data for Columns A and B will link
from the Week 3 tab on this
spreadsheet - no need to re-input!
• The green cells (G3 and G4) will link
.
from the Week 3 tab on this
spreadsheet.
Only cells that are yellow need to be
completed.
Transcribed Image Text:A B D E G Note: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failed assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework. 95% Confidence Interval for Average Age of Online College Students: 2 3 Age 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 33 M 34 M 35 F 20 F 18 F 19 M 45 F 33 M 24 M 37 F 26 M 24 25 26 27 28 Gender 29 30 31 32 33 34 32 F 32 F 18 F 35 16 M 37 F 23 F 4 28 F 77 F 50 F 22 M 25 M 26 F 30 M 25 M 24 M Week 3 Points 1 2 2 2 1 1 2 1 1 2 2 2 2 1 Sample Mean: Sample St. Dev: Sample Size: 1 Distribution: Critical Value: Margin of Error: Lower Bound: Upper Bound: Interpret (context) Sample Size: Number of Males: Male Proportion: Distribution: Critical Value: 95% Confidence Interval for Proportion of Male Online College Students: Margin of Error: Lower Bound: Upper Bound: 28.88 12.92 Interpret 2 (context) Week 5 Week 6 Project Help *2 decimals + *2 decimals Calculation: *2 decimals Calculation: *2 decimals Calculation: Female Proportion *2 decimals Note: Calculation cells should list the numbers and operations used to get your answers. Do not put the generic formula and show all calculation steps. 4 decimals Calculation: *4 decimals Calculation: *4 decimals Calculation: *4 decimals Help for this spreadsheet • Review 8.2 of your text as well as the Project Help tab below for the first confidence interval calculation (mean). Also watch Excel videos in BlackBoard. • Review 8.3 of your text as well as the Project Help tab below for the second confidence interval calculation . (proportion). Also watch Excel videos in BlackBoard. ● "Show Your Calculation" - these cells should list the numbers and operations used to get your answers. Do not just put the general formula and show all calculation steps. Do not put "=" in formulas so I can see the formula by just looking at the cell, not opening it. . For the "Interpret" text, what can we conclude about the population mean age and the population male proportion of online students with respect to these bounds? • Your data for Columns A and B will link from the Week 3 tab on this spreadsheet - no need to re-input! • The green cells (G3 and G4) will link . from the Week 3 tab on this spreadsheet. Only cells that are yellow need to be completed.
For this part of the project and based on the class sample, you will create a 95% confidence
interval for the mean age and the proportion of males in the population of all online college
students.
Note: The goal of the project is to practice making a confidence interval for a mean and
proportion with real data. Do not worry about failed assumptions tests and do not make
corrections for small sample size. Use primary methods described in text and used on homework.
Using the same excel sheet you submitted for Part 2, answer the following in the "Module 5" tab:
● For the average age, form a 95% confidence interval:
What distribution should be used?
What is the critical value?
What is the error bound?
What is the lower bound?
What is the upper bound?
How do we interpret the results, in context of our study?
For the proportion of males, form a 95% confidence interval:
●
O
O
D 0 0 0 0
O What distribution should be used?
0 0 0 0 0 0
What is the critical value?
What is the error bound?
What is the lower bound?
What is the upper bound?
How do we interpret the results, in context of our study?
Transcribed Image Text:For this part of the project and based on the class sample, you will create a 95% confidence interval for the mean age and the proportion of males in the population of all online college students. Note: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failed assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework. Using the same excel sheet you submitted for Part 2, answer the following in the "Module 5" tab: ● For the average age, form a 95% confidence interval: What distribution should be used? What is the critical value? What is the error bound? What is the lower bound? What is the upper bound? How do we interpret the results, in context of our study? For the proportion of males, form a 95% confidence interval: ● O O D 0 0 0 0 O What distribution should be used? 0 0 0 0 0 0 What is the critical value? What is the error bound? What is the lower bound? What is the upper bound? How do we interpret the results, in context of our study?
Expert Solution
Introduction

* Hi! Thank you for the question As per the honour code, We’ll answer the first question since the exact one wasn’t specified. 
Please submit a new question by specifying the one you’d like answered in the remaining questions

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman