# need help

Then the 27 listed insurance agents Nationwide Insurance in the metropolitan area of Toledo, Ohio. Calculate the average number of years that have worked in Nationwide.

See attached.

a) Select a random sample of four agents. If the Random numbers selected are: 02,59,51,25,14,29,77,69 and 18, then which dealers will be included in the sample?

b) Use the table of random numbers to select their own sample of four agents.

c) A sample consists of every seventh dealer. The number 04 is selected as a starting point. Which members will be included in the sample?

https://brainmass.com/statistics/central-limit-theorem/insurance-agents-nationwide-ohio-531919

#### Solution Preview

I have answered the questions in your posting in the attached MS Word doc.

a) select a random sample of four agents. If the Random numbers selected are: 02,59,51,25,14,29,77,69 and 18, then which dealers will be included in the sample?

If the random numbers 02, 59, 51, 25, 14, 29, 77, 69 and 18 were selected then that means that Agents number 02, 59, 51, 25, 14, 29, 77, 69 and 18 should be included in your sample. Now a problem arises because in your sampling frame (the list of 26 agents that you provided) there are no agents corresponding to the numbers 59, 51, 29, 77 or 69. In this case we ignore those numbers and keep the 4 random numbers for which there ARE agents on the list. So this list of nine random two-digit numbers would yield the following four agents:

02: Denker, Brett

Skip the 59 and 51 since there are no agents in this table that ...

#### Solution Summary

The solution assists with calculating the average number of years that have worked in Nationwide.

How to Test a Hypothesis

I need help with hypothesis testing and excel.

I have attached the sample database for use.

Can you please explain how this is done in excel and what the statistical formulas are.

I do know that for a hypothesis test with .05 or 95% must compute the z-value which is actual - predit/som var - how do I do this.

1. Test a hypothesis to see whether the average overall job satisfaction (in the population of all workers in the USA) is equal to 4.5 with a = .05.

a. State the null hypothesis, the alternative hypothesis, and the significance level.

b. Using the data in our database, calculate the test statistic.

c. What is the critical level for the significance level?

d. What is your conclusion? Do we accept or reject the null hypothesis?

You may use Excel for the calculations, but you need to answer all four parts of this question.

2. Propose a hypothesis test for the mean intrinsic job satisfaction, similar to the test from problem 1, and answer parts a, b, c, and d of problem 1 for this hypothesis test. You may use Excel for the calculations, but you need to answer the four questions.

3. We believe that half of the population would have an extrinsic job satisfaction of 5.0 or greater. Answer parts a, b, c, and d of problem 1 for this hypothesis test of a proportion. You may use Excel for the calculations, but you need to answer the four questions.

4. We believe that the variance of the overall job satisfaction is equal to 1.0 Answer parts a, b, c, and d of problem 1 for this hypothesis test of a variance. You may use Excel for the calculations, but you need to answer the four questions.

5. We will call a "deskbody" a person whose intrinsic job satisfaction level is higher than their extrinsic job satisfaction level (i.e. happy with their job more than their office). We will call a "socialbody" a person whose extrinsic job satisfaction level is higher than their intrinsic job satisfaction level (i.e. happy with the office more than their job). We believe that there are equal deskbodies and socialbodies in the work force.

a. State an appropriate null hypothesis and its alternative hypothesis.

b. In our database, what percent of the employees are deskbodies? Are socialbodies?

c. What did you do with the employees who had equal intrinsics and extrinsics?

6. Determine the required sample size if you need to estimate the number of workers in the United States who are highly satisfied with their job and you want the estimate to be within 2 percentage points with a 96% confidence interval.