Question

The president of a personnel agency is interested in examining the annual mean salary differences between vice presidents of commercial banks and vice presidents of savings and loans institutions. She matches eight bank vive presidents with the vice presidents of comparable savings and loans. Their annual salaries (in dollars) are given below. D the data provide sufficient evidence to conclude there is a difference in the mean salaries Test at the. 10 level of significance. Pair <ULUI Banks 97800 88746 129738 147095 64402 74732 102129 81588 Savings and Loans 97800 78403 77311 143035 116684 78482 86312 98445

Get the Excel output.

Answer 1

Above problem is solved using Excel, Output of excel is attached below

New Microsoft Excel Worksheet - Microsoft Excel - 2 X File Home Insert Page Layout Formulas Data Review View * Cut M AutoSum - A Fill Z Tu Insert Delete Format Styles 2 Clear Sort & Filter Editing Find & Select Cells I J K L M N O Calibri 11 AA = = E D Wrap Text General Copy Paste Format Painter BIU A Es Merge & Center 9 % , Formatting as Table Clipboard Font Alignment Number Styles A1 for Banks A B C G H 1 Banks Savings and loans t-Test: Two-Sample Assuming Equal Variances 97800 97800 88746 78403 Banks Savings and loans 129738 77311 Mean 98278.75 97059 147095 143035 Variance 779900340.8 528576579.4 64402 116684 Observations 74732 78482 Pooled Variance 654238460.1 102129 86312 Hypothesized Mean Difference 81588 98445 df t Stat 0.095374613 P(T<=t) one-tail 0.462684497 t Critical one-tail 1.761310136 P(T<=t) two-tail 0.925368994 t Critical two-tail 2.144786688 Hypothesis, HO:1 = 42 H1:41 * 2 Decision, P-Value = 0.9254 As P-Value(0.9254) > alpha(0.10) Ho is Accepted. Conclusion: Therefore at 10% level of significance we conclude that the claim is false that there is difference in mean salaries Sheet1 Sheet2 Sheet3 ► Ready Count: 2 001 100% G No new notifications 4 0 M 4) ENG 26-04-2020 01:11 Type here to search 0

Dear student,

I am waiting for your feedback. I have given my 100% to solve your queries. If you satisfied with my answer then please please like this.

Thank You