Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. a random sample of 28 statistics tutorials was sel

A random sample of 28 statistics tutorials was selected from the past 5 years and the...

50.1K

Verified Solution

Question

Basic Math

A random sample of 28 statistics tutorials was selected from thepast 5 years and the percentage of students absent from each onerecorded. The results are given below. Assume the percentages ofstudents' absences are approximately normally distributed. UseExcel to estimate the mean percentage of absences per tutorial overthe past 5 years with 90% confidence. Round your answers to twodecimal places and use increasing order.

Number of Absences

13.9

16.4

12.3

13.2

8.4

4.4

10.3

8.8

4.8

10.9

15.9

9.7

4.5

11.5

5.7

10.8

9.7

8.2

10.3

12.2

10.6

16.2

15.2

1.7

11.7

11.9

10.0

12.4

Answer & Explanation Solved by verified expert
4.0 Ratings (585 Votes)
Enter the data of 28 values Sample size n 28ExcelFormulaeAVERAGEA2A29 mean in cell A30STDEVA2A29    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Accounting
1.2K views

The unadjusted trial balance of Epicenter Laundry at June 30,2019, the end of the...

Basic Math
1.2K views

2. The strength of an association is one of the criteria for evaluating the cause and...

Accounting
1.2K views

Explain the difference between Limited and Reasonable Assurance, also give one example of each. Need Examples and...

Basic Math
1.2K views

How are the FAFSA, SAR, and EFC related?The FAFSA is what you fill out to...

Statistics
1.2K views

The test scores of the students in four dasses are summarized below Answer the questions...

Accounting
1.2K views

the following are the inventories for Year 2, Year 3, and Year 4 for Parry...

Accounting
1.2K views

The is a protectionist argument that says the U.S. should use tariffs to...

Accounting
1.2K views

headland inc isued 3900000 of 11% 10 year convertible bonds on June 1, 2020 at...

Accounting
1.2K views

Brief Exercise G-15 Sunland Company is about to issue $262,700 of 6-year bonds paying an...

Accounting
1.2K views

Edward purchased a new piece of equipment to be used in its new facility. The...

Finance
1.2K views

6. Abbey Taylor, CFA, has been directed to determine the value of Sundanci's stock using...

Finance
1.2K views

Sample size . Discuss 10 Sample procedures or or methods for calculating or point 2...