I am trying to finish a project and I am stuck on a few sections of this spreadsheet I need help with blocks for sample size, state of conclusion, the second sample size, number of males, male proportion and the last state of conclusion.
Safari File Edit View History Bookmarks Window Help 19 & Sat 10:05 PM Q learn.liberty.edu C Homework Help - Q&A from Online Tutors - Course Hero + Student Project Upload Assignment: Project: Confidence Intervals Assignment &... Work Sh...Isx.cpgz MATH 201-B10 LUO Announcements Student Project Course Content Work Sh...x 2.cpg Grades/Tools ASSIGNMENT INFORMATION Textbook (s) Student Project Work Sh...x 3.cpgz Link to ALEKS Due Date Points Possible Discussions Monday, February 14, 2022 25 Shadow 5.0.1067 Calendar 11:59 PM Faculty Information Steam Liberty Webmai 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. Services/Support 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 Writing Style Guide 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 as last week, answer the following in the "week 5" tab: . For the average age, form a 95% confidence interval: o What distribution should be used? . What is the critical value? o What is the error bound? o What is the lower bound? o What is the upper bound? o How do we interpret the results, in context of our study? . For the proportion of males, form a 95% confidence interval: What distribution should be used? o What is the critical value? . What is the error bound? o What is the lower bound? o What is the upper bound? o How do we interpret the results, in context of our study? Submit this assignment by 11:59 p.m. (ET) on Monday. ASSIGNMENT SUBMISSION When finished, make sure to click Submit. Cancel Save Draft Submit Screen Shot 2022-02...7.00 PM Optionally, click Save as Draft to save changes and continue working later, or click Cancel to quit without saving changes. 1BEE 4 FEB 19Excel e Edit View Insert Format Tools Data Window Help 20 & Sun 11:06 PM Q = ... AutoSave ON . A B3 9 . C ... Student Project Work Sheet Spring B Term - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments & Cut Calibri (Body) 12 AA g Wrap Text v General Normal Bad Good Neutral 2 AutoSum [B) Copy Fill Paste BIUV v Av Merge & Center v $ ~ % " 00 20 Conditional Format Calculation Check Cell Explanatory T... Followed Hyp.. Insert Delete Format Sort & Find & Analyze Format Formatting as Table Clear Filter Select Data 124 X fo Female Proportion A B c G H M P Q R S T U v w X Y Z AA AB AC AD AE BEFORE BEGINNING, PLEASE VIEW MY VIDEO TUTORIAL FOR THIS PROJECT - THE LINK IS FOUND IN OUR WEEK 5 ANNOUNCEMENTS Review your ALEKS e-text sections 8.2, 8.3 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 2 primary methods described W Age Gender Use a 95% Confidence Interval for Average Age of Online College Students: 22 POINT DISTRIBUTION 19 Point Values Points Earned Sample Mean: 28.60 23 Sample St. Dev: 9.20 Sample Size: 2 Distribution: T-Distribution (Choose from drop-down menu) 2 Critical Value: a = 0.05 Margin of Error: 2.106 HAN Lower Bound: 30.50224 Upper Bound: 38.75776 State a 2 conclusion: 95% Confidence Interval for Proportion of Male Online College Students: Sample Size: Number of Males: Male Proportion: Female Proportion Distribution: T-Distribution (Choose from drop-down menu) HAN N N NAP Critical Value: a = 0.05 Margin of Error: 3.34581 Lower Bound: 25.44221 Upper Bound 38.55779 State a G N conclusion: 0 = 0% Week 3 Week 5 Week 6 Project - Video Helps + Ready -+ 100% 4 FEB 20
