BUSI 230
kromamich
StudentAnswerSheet202240BUSI230-B15.xlsxWeek 3
| Age | Gender | For the following questions, use only the "age" column: | |||||||||||
| 30 | M | ||||||||||||
| 17 | F | Points | Age Frequency Distribution: | Class Width | |||||||||
| 25 | F | ||||||||||||
| 38 | F | Class Limits | Midpoint | Freq. | Relative Frequency | Cumulative Relative Freq | |||||||
| 18 | M | Low | High | ||||||||||
| 22 | F | Limits | 2 | ||||||||||
| 41 | F | Freq. | 2 | ||||||||||
| 42 | F | Mid. | 2 | ||||||||||
| 18 | M | RF | 2 | ||||||||||
| 22 | M | CF | 1 | ||||||||||
| 25 | M | ||||||||||||
| 20 | M | 2 | Mean | *Round to two decimals | |||||||||
| 24 | M | 2 | Median | *Round to one decimal | |||||||||
| 30 | M | 2 | Sample Standard deviation: | *Round to two decimals | |||||||||
| 18 | M | 2 | Q1 | *Round to one decimal | |||||||||
| 36 | F | 2 | Q3 | *Round to one decimal | |||||||||
| 44 | F | ||||||||||||
| 39 | F | ||||||||||||
| 28 | M | Ogive: | 3 | ||||||||||
| Polygon | 3 | ||||||||||||
| Ogive: | Polygon: | ||||||||||||
| Total: | 25 | ||||||||||||
Help for this spreadsheet • Review 2.2, 3.1 – 3.3 of your text. Also watch Excel Videos in BlackBoard. • Your data is already copied into columns A and B. • Only cells in yellow need to be completed. • Choose a class width according to the following equation (rounded up to whole number): CLASS WIDTH = (MAX VALUE - MIN VALUE)/# of Classes (5) • The ogive and polygon graphs need to be included on this page under the headers below. Please do not put them on a separate page.
Week 5
| 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. | |||||||||||||
| Age | Gender | Points | 95% Confidence Interval for Average Age of Online College Students: | ||||||||||
| 30 | M | ||||||||||||
| 17 | F | Sample Mean: | 0 | 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. | |||||||||
| 25 | F | Sample St. Dev: | 0 | Normal Distribution | |||||||||
| 38 | F | 1 | Sample Size: | T-Distribution | |||||||||
| 18 | M | ||||||||||||
| 22 | F | 2 | Distribution: | ||||||||||
| 41 | F | ||||||||||||
| 42 | F | 2 | Critical Value: | *2 decimals | |||||||||
| 18 | M | ||||||||||||
| 22 | M | 2 | Margin of Error: | *2 decimals | Calculation: | ||||||||
| 25 | M | 1 | Lower Bound: | *2 decimals | Calculation: | ||||||||
| 20 | M | 1 | Upper Bound: | *2 decimals | Calculation: | ||||||||
| 24 | M | ||||||||||||
| 30 | M | Interpret (context) | |||||||||||
| 18 | M | 2 | |||||||||||
| 36 | F | ||||||||||||
| 44 | F | 95% Confidence Interval for Proportion of Male Online College Students: | |||||||||||
| 39 | F | ||||||||||||
| 28 | M | 1 | Sample Size: | ||||||||||
| 1 | Number of Males: | ||||||||||||
| 2 | Male Proportion: | Female Proportion | *4 decimals | ||||||||||
| 2 | Distribution: | ||||||||||||
| 2 | Critical Value: | *2 decimals | |||||||||||
| 2 | Margin of Error: | *4 decimals | Calculation: | ||||||||||
| 1 | Lower Bound: | *4 decimals | Calculation: | ||||||||||
| 1 | Upper Bound: | *4 decimals | Calculation: | ||||||||||
| Interpret (context) | |||||||||||||
| 2 | |||||||||||||
| 25 | Total Points | ||||||||||||
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. • Please note rounding for calculations!
Week 6
| Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry about failed assumptions tests. Use primary methods described in text and used on homework. | ||||||||||||
| For the following two hypothesis tests, use alpha = .05 | ||||||||||||
| Points | Claim: The average age of online students is 32 years old. Can you prove it is not? | |||||||||||
| Normal Distribution | ||||||||||||
| 1 | Ho: | 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. | T-Distribution | |||||||||
| 2 | Ha: | |||||||||||
| Sample mean: | 0 | |||||||||||
| Sample St. Dev: | 0 | |||||||||||
| 2 | Distribution: | |||||||||||
| Reject Ho | ||||||||||||
| 2 | Test Statistic: | *2 decimals | Calculation: | Fail to Reject Ho | ||||||||
| 2 | p-value: | *4 decimals | ||||||||||
| 1 | Decision: | |||||||||||
| 2 | Interpretation: (context) | |||||||||||
| Claim: The proportion of males in online classes is 35%. Can you prove it is not? | ||||||||||||
| 1 | Ho: | |||||||||||
| 2 | Ha: | |||||||||||
| Sample Proportion Males | 0 | Sample Proportion Females | 0 | |||||||||
| 2 | Distribution: | |||||||||||
| 3 | Test Statistic: | *2 decimals | Calculation: | |||||||||
| 2 | p-value: | *4 decimals | ||||||||||
| 1 | Decision: | |||||||||||
| 2 | Interpretation: (context) | |||||||||||
| 25 | Total Points |
Helps for this spreadsheet: § Review 9.1 of your text as well as the Project Help tab below for stating your null and alternate hypotheses. § Review 9.3 of your text as well as the Project Help tab below to do a hypothesis test for a population mean. Also watch the Excel videos. § Review 9.4 of your text as well as the Project Help tab below to do a hypothesis test for a population proportion. Also watch the Excel videos. § "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 null hypothesis with respect to the evidence produced by the hypothesis test? What does this mean about the average age and male proportion of all online college students? § The green cells (E8 and E9) will link from the Week 3 tab on this spreadsheet. § The green cells (F24 and J24) will link from the Week 5 tab on this spreadsheet. § Only cells that are yellow need to be completed. § Please note rounding for calculations!
Project Help
| TI-84 PLUS VIDEO HELPS FOR STATS PROJECT | |
| Week 3: Project Part 2 - Descriptive Statistics | |
| How do I do a frequency distribution? | Chapter 2, Section 2: Frequency Distributions and Histograms for Quantitative Data |
| What do I need to know about a frequency polygon and ogive? | Chapter 2, Section 2: Frequency Polygons and Ogives |
| How do I calculate the mean and median? | Chapter 3, Section 1: Mean and Median on the TI-84 Plus |
| How do I calculate the standard deviation? | Chapter 3, Section 2: The Variance and Standard Deviation on the TI-84 Plus |
| How do I calculate the quartiles, Q1 and Q3? | Chapter 3, Section 3: Quartiles and the Five Number Summary on the TI-84 Plus |
| Week 5: Project Part 3 - Confidence Intervals | |
| How do I determine what type of distribution is being used? (View at 8:45 into video) | https://www.youtube.com/watch?v=TWIp3w0eQaA&feature=youtu.be |
| How do I create a confidence interval for a population mean? | Chapter 8, Section 2: Confidence Intervals for a Population Mean with Standard Deviation Unknown (TI-84 PLUS) |
| Chapter 8, Section 2: Exercise Video - Confidence Interval for the Mean with Sigma Unknown (TI-84 PLUS) | |
| How do I create a confidence interval for a population proportion? | Chapter 8, Section 3: Confidence Intervals for a Population Proportion (TI-84 PLUS) |
| Chapter 8, Section 3: Exercise Video - Confidence Interval for a Proportion Using the TI-84 PLUS | |
| Week 6: Project Part 4 - Hypothesis Testing | |
| How to I write my null and alternate hypotheses? | Chapter 9, Section 1: Null and Alternate Hypotheses |
| Chapter 9, Section 1: Exercise Video - State the Null and Alternate Hypothesis | |
| How do I do a hypothesis test for a population mean? | Chapter 9, Section 3: Hypothesis Tests for a Population Mean (SD Unknown, P-Value Method Using TI-84 PLUS) |
| Chapter 9, Section 3: Exercise Video - Hypothesis Test for Mean with Sigma Unknown - P-Value Method (TI-84 PLUS) | |
| How do you do a hypothesis test for a population proportion? | Chapter 9, Section 4: Hypothesis Tests for a Population Proportion (P-Value Method Using the TI-84 PLUS) |
| Chapter 9, Section 4: Exercise Video - Hypothesis Test for Proportions - P-Value Method (TI-84 PLUS) | |
| How do I come to a decision and state my interpretation once I have done my hypothesis test? | Chapter 9, Section 1: Stating Conclusions in a Hypothesis Test |
Each of the following that have a Chapter/Section Reference can be found in Connect Math. Click on RESOURCES, VIDEOS and then choose the chapter and section. Then find the name of the listed video to view.
https://www.youtube.com/watch?v=TWIp3w0eQaA&feature=youtu.be
