LAB
Echems3
3 years ago
35
files (3)3Week_3_Descriptives_MATH225N.xlsx
MATH225_Lab_5_Lecture_Notes.docx
5Week_5_NormalDistribution_Math_225N_1.xlsx
3Week_3_Descriptives_MATH225N.xlsx
Descriptives
| Enter the data in the blue highlighted area and the results will show in the yellow highlighted area. | ||||||||||
| Data | ||||||||||
| 1 | Mean | 3.5000 | ||||||||
| 2 | Median | 3.5000 | ||||||||
| 3 | Mode | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | (Returns more than one mode) | |||
| 4 | Sample Variance | 3.5000 | ||||||||
| 5 | Sample Standard Deviation | 1.8708 | ||||||||
| 6 | Population Variance | 2.9167 | ||||||||
| Population Standard Deviation | 1.7078 | To find boundary for outliers | ||||||||
| Range | 5.0000 | |||||||||
| Count (n) | 6.0000 | 1.5 IQR | 4.5 | |||||||
| Min | 1.0000 | Lower boundary | Q1-1.5IQR | -2.5000 | ||||||
| Quartile 1 | 2.0000 | Upper boundary | Q3+1.5IQR | 9.5000 | ||||||
| Median | 3.5000 | Identify outliers in your given data set. If the data is not between the lower and upper boundary then it is an outlier | ||||||||
| Quartile3 | 5.0000 | |||||||||
| Max | 6.0000 | |||||||||
| Interquartile Range (IQR) | 3.0000 | |||||||||
MATH225_Lab_5_Lecture_Notes.docx
You will need two excel spreadsheets in order to complete this lab.
1. Go to Modules in the course room and click on Week 3 Lesson: Measure of Central Tendency and Variation.
2. Download the excel spreadsheet template needed for the lab.
3. Go to Modules in the course room and click on Week 5 Lesson: Normal Distribution.
4. Download the excel spreadsheet template needed for the lab.
Data Set: Ten Grades on the Midterm Exam
|
50 |
68 |
74 |
77 |
80 |
|
86 |
86 |
80 |
78 |
90 |
· Create a description spreadsheet to describe the students surveyed.
a. How did you choose the participants for your study (sampling method)?
Review Different Types of Sampling Methods
1. Cluster: ____________________________________________________________
2. Stratified: ___________________________________________________________
3. Systematic: _________________________________________________________
4. Convenient: _________________________________________________________
5. Simple Random: _____________________________________________________
b. What part of the country did your study take place in?
c. What are the age ranges of your participants?
d. How many of each gender did you have in your study?
e. What are other interesting factors about your group?
--Take a Screenshot of your Description Spreadsheet and provide it below.
--Take a Screenshot of your Preliminary Calculations and provide it below.
· Preliminary Calculations
|
Mean |
|
|
Sample Standard Deviation |
|
|
Score on the Midterm |
|
· Let’s Compare Our Score!
How does your score compare to the mean (average) height of the group that you surveyed? Is your score more, less, or the same as the mean of your group?
Empirical Rule
Determine the 68%, 95%, and 99.7% values of the Empirical Rule in terms of the ten scores in your midterm study.
--Take a Screenshot of your Empirical Rule Sheet and provide it below
What do these values tell you?
Normal Distribution
--Take a Screenshot of your Normal Distribution Sheet and provide it below
Based on your study results, what percent of the study participants scored lower than you? What percent scored better?
Recap of Week 5 Lab
image3.png
image4.png
image1.png
image2.png
5Week_5_NormalDistribution_Math_225N_1.xlsx
Normal probability
| Enter input in blue cells; See answers in yellow cells | ||||||||
| ANSWER | ||||||||
| Z score | x | 3.5 | Z score | -2 | ||||
| mean | 6.5 | |||||||
| standard deviation | 1.5 | |||||||
| LESS THAN(At most) | AREA LESS THAN | ENTER | Z score | 0.8 | ||||
| Asked to find x | 32 | Probability Less than F7 | 0.7881 | |||||
| Mean | 28 | |||||||
| Stdev | 5 | |||||||
| MORE THAN (at least) | AREA MORE THAN | ENTER | Z score | -0.6666666667 | ||||
| Asked to find x | 12 | Probability more than F13 | 0.7475 | |||||
| Mean | 14 | |||||||
| Stdev | 3 | |||||||
| Probability INBETWEEN | ENTER | ANSWER | ||||||
| INBETWEEN | Asked to find Large value | 370 | Probability between F19 and F20 is | 0.6904 | ||||
| Asked to find smaller value | 360 | |||||||
| Mean | 365.45 | |||||||
| Stdev | 4.9 | |||||||
Find x given probability
| Enter input in blue cells; See answers in yellow cells | ||||||
| Find x given Area to Right or Left | Enter | |||||
| Area to the left | no | If area to the left is given enter yes; otherwise say no | ||||
| Area | 0.03 | enter decimal | SUMMARY | |||
| Enter Mean | 47500 | z | 1.8807936082 | |||
| Enter Standard deviation | 3000 | Find x | 53142.3808244538 | |||
| Find X given Area in the middle | ||||||
| Area | 0.5 | enter decimal | SUMMARY | |||
| Enter Mean | 81 | Lower x | 78.3020409992 | |||
| Enter Standard deviation | 4 | Upper x | 83.6979590008 |
Empirical Rule
| Enter input in blue cells; See answers in yellow cells | |||||||||
| ANSWER | |||||||||
| Empirical Rule | 68-95-99.7 | ||||||||
| mean | 92 | Lower number | Upper number | ||||||
| standard deviation | 13 | 68% | 79 | 105 | |||||
| 95% | 66 | 118 | |||||||
| 99.70% | 53 | 131 |
CLT Theorem
| Enter input in blue cells; See answers in yellow cells | |||||||
| CLT THEOREM FOR MEANS | Standard error | 2.8366 | |||||
| n | 10 | ||||||
| Standard deviation | 8.97 | ||||||
| CLT THEOREM FOR PROPORTION | Standard error | 0.0913 | |||||
| n | 30 | ||||||
| proportion of success | 0.5 |
image1.emf
image2.emf
image3.emf
image4.jpeg
- CIS333 Assignment
- Baron, D. P. (2010). Business and its environment (6th ed.). Upper Saddle River, NJ: Prentice Hall
- Medical law and ethic syllabus Unit case study page 43
- FOR PHYLLIS YOUNG ONLY-MGMT 436
- accident investigation unit I assessment 6 questions and one DQ question
- Quality and Uses of Health Information including confidentiality and compliance
- HRM 599 Assignments Week 2,3,5 Benefits
- Financial Statement Analysis
- Business negotition questions
- Virtualization and Cloud Computing World
