The following data represent data gathered from the statistics courses I taught in Spring of 2020 while teaching remotely. P represents pass, and NP represents not pass. Each row is an individual student. Click this button to reveal the data Student Success_Sp_20 P P NP P P P P P P P P P P NP P P NP P P P P P P P P P P P P P NP P NP P P P P P P P P P P P P P P P P P P P NP P P P NP P P NP P P P P P P P P P NP NP P P P P P P P NP P NP P NP P P P P NP P P NP P P P P P P P P P P P Download CSV file Click Download CSV file or copy/paste the data into Excel. When you paste, use Paste Special and then select Unicode Text. After downloading .csv file, you may want to save it as a Excel Workbook or .XLSX file type. a. Use Excel to create a frequency table to count the number of students who passed (P) in the Excel sheet. Based on your table, the conditions to create a confidence interval for the proportion of my students who pass my statistics classes are met because there are at least 15 NPs and more than 15 Ps. True False Assume my students in Spring term of 2020 represent a random sample of my students. b. What is the point estimate for the proportion of students who pass my class? Round your answer to 3 decimal places properly, and answer as a proportion and not a percent.

Holt Mcdougal Larson Pre-algebra: Student Edition 2012

1st Edition

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

Chapter11: Data Analysis And Probability

Section11.2: Box-and-whisker Plots

Problem 1E

See similar textbooks

Related questions

Question

100%

c. What is the margin of error for a 91% confidence interval for the proportion of students who pass my class?
Round your answer to 3 decimal places properly, and answer as a proportion and not a percent.

me =

d. Choose the best interpretation of the confidence interval you made for proportion of students that pass my class. Show the work to calculate this interval on the document.

I am 91% confident that between 0.791 and 0.911 of students pass your statistics classes.
There is a 91% probability that 85.1% of your students pass.
I am 89% confident that between 79.4% and 90.8% of students pass your statistics classes.
I am 91% confident that the sample proportion is between 0.791 and 0.911.

PLEASE SOLVE THESE CORRECTLY and for the questions that have math please give me the equations for excel.