Question: 1a)Using this excel, calculate confidence interval for the hourly salary of the state government workers. Also, while doing so, calculate the the margin of error

1a)Using this excel, calculate confidence interval for the hourly salary of the state government workers. Also, while doing so, calculate the the margin of error for estimating the average hourly amounts paid. Make sure to use a confidence level of 98%. Assume no population standard deviation is given. Show all of your calculation/s in detail.

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!

The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. Required: Calculate...

QUESTION 1 Which statement(s) about the standard error of the mean is(are) true? A. The standard error of the mean is never larger than the standard deviation of the population. B. The standard error...

The questions are in the photos below: Question 1 Not yet answered Marked out of 1.00 F Flag question If a sample of size n is drawn from a population with mean u and standard deviation 0, which of...

UNIVERSITY CANADA WEST Assignment 3 Total of 25 marks-Worth 6.25% of the course grade Assignment rules + Provide your solutions in the MS WORD file provided after each question. + Your uploaded file...

Econ 295, Fall 2017, Prof. Lesica DU E : December 6, 2017 ASSIGNMENT 3, Points: 60 + 6 Bonus F F F F F AT THE BEGINNING OF CLASS ONLY This is not a group assignment. Even if you work in a group, you...

1 (1 point) The average battery life of the iPhone 4S is reported to be 6.0 hours. Assume that the standard deviation for the battery life for this cell phone is 36 minutes. A random sample of 42...

Please help me solve this question 1. [2/4 Points] DETAILS PREVIOUS ANSWERS MENDSTAT14 8.E.007. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Calculate the 95% margin of error in estimating a binomial...

please help me with these questions much appreciated 1. [2/4 Points] DETAILS PREVIOUS ANSWERS MENDSTAT14 8.E.007. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Calculate the 95% margin of error in...

7 - Calculate the 95% margin of error in estimating a binomial proportion p for the following sample size. Use p = 0.6to calculate the standard error of the estimator. (Round your answer to three...

18-46. According to the Office of Personnel Management (www.OPM.gov), in 2015 the average hourly wage rate for federal employees was slightly higher than $43. The file titled Paychecks contains a...

What are four reasons why an FI may prefer the use of either pass-through securities or CMOs to the use of MBBs?

1. Prove each of the following for all n > 1 by the Principle of Mathematical Induction. a) 1 + 3 +5 +.... b) 1.3 +2.4 +3.5 +...+n(n + 2) = n(n + 1)(2n + 7) 6 + (2n 1)2 = n(2n 1)(2n + 1) 3 1 ii +...

The nurse enters a 52-year-old patient's room to find the patient worried and depressed. The nurse warmly greets the patient and lightly touches her shoulder. Which type of touch is this? Caring,...

You have been asked to determine the amount available for the unsecured claims, calculate the cents on the dollar that the unsecured creditors are estimated to get, and calculate the estimated...