Enclosed is a file called EAI. It is identical to the file in chapter 7 of the text with the addition of a column of random numbers. It contains a population of 2500 managers including their annual...

1 answer below »
the assignment and data is attached


Enclosed is a file called EAI. It is identical to the file in chapter 7 of the text with the addition of a column of random numbers. It contains a population of 2500 managers including their annual salary as well as whether or not they attended a training program. Using this file, and the given random numbers answer the following questions (neatly and clearly.) Show work. 1. Using PivotTable, create a crosstab giving salaries in the rows and training program in the columns. Group the salaries in an appropriate way. 2. Present two line graphs on the same set of axes comparing the salaries for those with and without the training program. 3. Comment on whether there is a significant difference between the salaries of those who took the training and those who did not. If so, what is it? Would you recommend taking the program? 4. Now use the given random numbers to get a random sample of 100 records from the file. List those records. 5. Using this sample, and knowing the population standard deviation to be $4,000, find a 90% confidence interval for the Annual Salary. Does your interval contain the population mean? Is it possible that it would not? If it is possible that it does not contain the population mean, what is the purpose of getting the interval? 6. How large a sample would be needed in order to get a 90% confidence interval of size $1,000 (so that the margin of error is 500)? 7. Now, assuming that you have only this random sample (i.e. that the population standard deviation is not available), find again a 90% confidence for the mean salary in the population. How and why is your answer different from that of question 5? 8. Using your sample, what it a point estimate of the percentage who took the training program. 9. Give a 90% confidence interval for this percentage. 10. Management would like to show that the mean salary of the population is under $52,000. What are the hypotheses (What needs to be shown should be in the alternate hypothesis)? What is the p value? Does the sample support this contention at α=0.10 level? For this question, assume that the population standard deviation is known and is $4,000.
eai-project-spring-2021-tagged-q5qdzlij.pdf eai-project-spring-2021-data-tap2hz0n.xlsx
Answered 1 days AfterMay 08, 2021

Answer To: Enclosed is a file called EAI. It is identical to the file in chapter 7 of the text with the...

Atreye answered on May 10 2021
128 Votes
Data
    Manager    Annual Salary    Training Program    RN    Annual Salary    RN    Training Program
    1    55769.50    No    0.7704310689    55769.50    0.7704310689    No            Question 1                            Question 2
    3    48408.20    No    0.9335912473    48408.20    0.9335912473    No
    4    49787.50    No    0.9538127942    49787.50    0.9538127942    No            Sum of Annual Salary    Column Labels
    6    51767.70    No    0.2979950484    51767.70    0.2979950484    No            Row Labels    No    Yes    Grand Total
    8    46670.20    No    0.4138672495    46670.20    0.4138672495    No            40990.3-41990.3    248229.6    455221.1    703450.7
    10    51255.00    No    0.7650875448    51255.00    0.7650875448    No            41990.3-42990.3    253911.6    170575.4    424487
    11    52546.60    No    0.5223690827    52546.60    0.5223690827    No            42990.3-43990.3    565440.7    608435.4    1173876.1                                    
    14    53547.10    No    0.6558077764    53547.10    0.6558077764    No            43990.3-44990.3    1293768.4    1915014.6    3208783
    15    48052.20    No    0.4316304447    48052.20    0.4316304447    No            44990.3-45990.3    1634492.8    1866208.2    3500701
    22    52973.60    No    0.0126045053    52973.60    0.0126045053    No            45990.3-46990.3    2465464.8    2047885.1    4513349.9
    23    53372.50    No    0.355775554    53372.50    0.355775554    No            46990.3-47990.3    3093492.7    3562382.6    6655875.3
    30    44956.50    No    0.8970202666    44956.50    0.8970202666    No            47990.3-48990.3    4851012.7    3877883.4    8728896.1
    32    52245.20    No    0.6494035374    52245.20    0.6494035374    No            48990.3-49990.3    5250339    4749333.4    9999672.4
    33    52614.70    No    0.9123923885    52614.70    0.9123923885    No            49990.3-50990.3    6108195.9    5256399    11364594.9
    35    50113.40    No    0.9991782125    50113.40    0.9991782125    No            50990.3-51990.3    5253609.2    7263514.8    12517124
    40    50131.20    No    0.9309856325    50131.20    0.9309856325    No            51990.3-52990.3    3992592.2    9082524.7    13075116.9
    44    54276.00    No    0.8692762527    54276.00    0.8692762527    No            52990.3-53990.3    2890445.8    8135003.3    11025449.1
    49    46833.50    No    0.2913407717    46833.50    0.2913407717    No            53990.3-54990.3    3102389.4    7842105.9    10944495.3
    52    49782.20    No    0.0332327093    49782.20    0.0332327093    No            54990.3-55990.3    2995311.7    7216194.6    10211506.3
    53    54854.70    No    0.9923647258    54854.70    0.9923647258    No            55990.3-56990.3    2935251    4123231.5    7058482.5
    54    44457.10    No    0.7836491955    44457.10    0.7836491955    No            56990.3-57990.3    1320595.1    3733645    5054240.1
    56    50135.50    No    0.0811539507    50135.50    0.0811539507    No            57990.3-58990.3    1286106.9    2688645.1    3974752
    57    52496.60    No    0.6076982193    52496.60    0.6076982193    No            58990.3-59990.3    534777.9    1901525.5    2436303.4
    61    45356.80    No    0.6152407482    45356.80    0.6152407482    No            59990.3-60990.3    606745.2    1152074.6    1758819.8
    62    49569.50    No    0.3205089199    49569.50    0.3205089199    No            60990.3-61990.3    305530.4    675499.6    981030
    63    54164.80    No    0.0749503503    54164.80    0.0749503503    No            61990.3-62990.3        62281.1    62281.1
    66    59978.60    No    0.6548702308    59978.60    0.6548702308    No            62990.3-63990.3    63538.7    63174.4    126713.1
    67    48689.10    No    0.3910459609    48689.10    0.3910459609    No            Grand...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?