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. ABDEGNote: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failedassumptions 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:23 Age456789101112131415161718192021222333 M34 M35 F20 F18 F19 M45 F33 M24 M37 F26 M2425262728Gender29303132333432 F32 F18 F3516 M37 F23 F428 F77 F50 F22 M25 M26 F30 M25 M24 MWeek 3Points12221121122221Sample Mean:Sample St. Dev:Sample Size:1Distribution: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.8812.92Interpret2(context)Week 5 Week 6 Project Help*2 decimals+*2 decimals Calculation:*2 decimals Calculation:*2 decimals Calculation:Female Proportion*2 decimalsNote: Calculation cells shouldlist the numbers andoperations used to get youranswers. Do not put thegeneric formula and show allcalculation steps.4 decimals Calculation:*4 decimals Calculation:*4 decimals Calculation:*4 decimalsHelp for this spreadsheet• Review 8.2 of your text as well as theProject Help tab below for the firstconfidence interval calculation (mean).Also watch Excel videos in BlackBoard.• Review 8.3 of your text as well as theProject Help tab below for the secondconfidence interval calculation.(proportion). Also watch Excel videos inBlackBoard.●"Show Your Calculation" - these cellsshould list the numbers and operationsused to get your answers. Do not justput the general formula and show allcalculation steps. Do not put "=" informulas so I can see the formula by justlooking at the cell, not opening it.. For the "Interpret" text, what can weconclude about the population meanage and the population male proportionof online students with respect to thesebounds?• Your data for Columns A and B will linkfrom the Week 3 tab on thisspreadsheet - no need to re-input!• The green cells (G3 and G4) will link.from the Week 3 tab on thisspreadsheet.Only cells that are yellow need to becompleted. For this part of the project and based on the class sample, you will create a 95% confidenceinterval for the mean age and the proportion of males in the population of all online collegestudents.Note: The goal of the project is to practice making a confidence interval for a mean andproportion with real data. Do not worry about failed assumptions tests and do not makecorrections 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:●OOD 0 0 0 0O What distribution should be used?0 0 0 0 0 0What 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?

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:

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

See similar textbooks

Similar questions

The Gazelles are a professional soccer team based in a large city. At the team's home matches, children's admission is half- off. Among the 940 attendees at the last home match, 390 were children. At that match, the facilities manager took a sample of 63 attendees. He found that 29 of these attendees were children. For the facilities manager's sample, find and write with proper notation the population proportion and sample proportion of attendees who were children. Write the proportions as decimals (not percentages) rounded to two decimal places. (a) Population proportion: (Choose one) V (b) Sample proportion: (Choose one) V
Hello there, please help me out with this problem. Write clearly and thank you!
Simplify the following expression (Don't forgot attach your domain!) 2. -5x+4 2. x´ - 4x *You don’ t have to print this organizer for working but just follow it's direction & format.
How many instructions do i need in all?
The expression =IF(A1 > 9, 10*A1, 12*A1) is used in a spreadsheet.Find the result if A1 is 2 Find the result if A1 is 10.
The Sweet Encounter is a touring international candy festival. The festival's most popular product is rainbow lollipops. At one stop of the tour, the festival promoter took a sample of the products offered. He found that 14 of the 60 products in his sample were rainbow lollipops. Among the 960 products offered at that stop, 290 were rainbow lollipops. For the festival promoter's sample, find and write with proper notation the population proportion and sample proportion of products offered that were rainbow lollipops. Write the proportions as decimals (not percentages) rounded to two decimal places. (a) Population proportion: (Choose one) ? (b) Sample proportion: (Choose one) v
Lance is at a bus station. His friend is using the ATM machine to withdraw some money. Lance notices a stranger deceptively watching his friend type in the ATM pin. What should Lance's friend do The person watching lance’s friend typing the ATM pin is an example of . Lance's friend should .
A scientist investigated the effect of cross-fertilization on the heights of plants. In one study, the scientist planted 15pairs of a species of plant. Each pair consisted of one cross-fertilized plant and one self-fertilized plant grown in the same pot. The table available below gives the height differences, in eighths of an inch, for the 15 pairs. Each difference is obtained by subtracting the height of the self-fertilized plant from that of the cross-fertilized plant. Use the paired t-interval procedure to determine a 99% confidence interval for the difference between the mean heights of cross-fertilized and self-fertilized plants. Interpret the result. (Note: d=19.00 and sd=35.50.) The 99%confidence interval is from ____ eighths of an inch to_____ eighths of an inch. (Round to two decimal places as needed. Use ascending order.) Which statement below best interprets the confidence interval? A. There is 99%confidence that the difference between the…
How do you know when to put 1 or 0 in the chart in the dummy variable approach
Translate into QL Everyone who admires someone admires a musician
The Plush Zo store sells stuffed animals. The store is running a special on teddy bears this month. One day, the shopkeeper took a sample of stuffed animals at the store. She found that 4 of the 15 stuffed animals that she sampled were teddy bears. The store had 590 stuffed animals on that day, and 110 of those stuffed animals were teddy bears. For the shopkeeper's sample, find and write with proper notation the population proportion and sample proportion of stuffed animals that were teddy bears. Write the proportions as decimals (not percentages) rounded to two decimal places. (a) Population proportion: (Choose one) V ? (b) Sample proportion: (Choose one) ▼
Cheryl bicycles 12 mph with no wind. Against the wind, she bikes 8 miles in the same time that it takes to bike 14 miles with the wind. What is the speed of the wind? Fill in the table to translate the information from this problem if w represents the speed of the wind. Be sure to use parentheses appropriately, if needed in the expression and do not use any spaces.