Question: USING EXCEL. Find the p-value Do not round intermediate calculations. Round your answer to four decimals. The local pharmacy prides itself on the accuracy of

USING EXCEL. Find the p-value Do not round intermediate calculations. Round your answer to four decimals.

The local pharmacy prides itself on the accuracy of the number of pills that are dispensed in a 60-count prescription.A quality control representative randomly selected a sample of 40 prescriptions requiring 60 pills.Assume the sample came from a normally distributed population with a population standard deviation of 4.45.The representative recounted the number of pills in each prescription bottle.The sample mean was 62.05 pills.At the 0.05 significance level, test the null hypothesis that the population mean equals 60 versus the the two-sided alternative? Findthe p-value.Do not round intermediate calculations.Round your answer to four decimal places.Include the leading zero.Format:0.0000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Excel Output of the Binomial Distribution with n = 24, p = 0.15, and q = 0.85 Binomial distribution with n = 24 and p = 0.15 JAWN- OX P(X=x) 0.0202 0.0857 0.1739 0.2251 0.2085 0.1472 (Note: The Excel...

Good Morning, I need answers from these questions please. 1.) Part 3? (The second box on both for options are is/is not ) A test is made of Ho: u = 19 versus H : u > 19. A sample of size n = 49 is...

Problem 18-3 (Algo) Many of a bank's customers use its automatic teller machine to transact business after normal banking hours. During the early evening hours in the summer months, customers arrive...

Question 1 BiglOSweaters.com is a new company started last year by two recent college graduates. The idea behind the company was simple. They will sell premium logo sweaters for Big Ten colleges with...

PLEASE EXPLAIN HOW TO DO IT AND HOW TO USE THE EXCEL SHEET FOR IT IF NEEDED The local supermarket buys lettuce each day to ensure really fresh produce. Each morning, any lettuce that is left from the...

You are thinking of opening a small copy shop. It costs $ 4 , 5 0 0 to rent a copier for a year, and it costs $ 0 . 0 2 per copy to operate the copier. Other fixed costs of running the store will...

Chel Lynn Ally, owner of a local Subway shop, loaned $46,000 to Pete Hall to help him open a Subway franchise. Pete plans to repay Lynn at the end of 7 years with 4% interest compounded semiannually....

The financial statements for KTK Enterprise are as follows: KTK Enterprise Consolidated Balance Sheet For the financial years ended December 31, 2018 and 2019 Assets Cash Account receivables...

Discuss the difference between budgets and standard costs.

AccelAccel Sports Company makes snowboards, downhill skis, cross - country skis, skateboards, surfboards, and in - line skates. The company has found it beneficial to split operations into two...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.