Use the data below to test whether there is a significant difference in the prop

Question

Use the data below to test whether there is a significant difference in the proportion of companies whose earnings per share are more than $2.00 and the proportion of companies whose dividends per share are between $1.00 and $2.00. Let =0.05., show the procedure. Use Excel to do testing and show the result.

1

Company Earnings per Share Dividends per Share 1 2.08 0.22 2 2.08 0.63 3 3.56 0.36 4 0.08 0.6 5 2.19 1.4 6 1.01 0.34 7 2.76 1.4 8 1.14 2.8 9 3.8 1.1 10 5.41 2.83 11 0.89 1.04 12 1.06 1.13 13 3.14 1.52 14 1.18 0.02 15 0.16 0.9 16 4.95 2.28 17 4.88 1.1 18 1.59 1.8 19 1.7 0.33 20 2.31 0.16 21 2.15 2.58 22 7.7 3.24 23 1.2 0.91 24 2.08 1.23 25 3.63 1.76 26 1.73 1 27 0.33 0.38 28 1.03 1.8 29 2.86 0.2 30 0.71 0.5 31 3.37 1.63 32 3.57 1.92 33 1.3 0.2 34 2.39 0.32 35 1.18 0.78 36 1.66 0.35 37 1.19 0.62 38 1.57 1.61 39 1.4 0.54 40 3.18 1 41 1.66 1.5 42 3.47 1.04 43 2.41 0.85 44 3.34 0.77 45 0.79 0.48 46 0.21 1.96 47 2.66 1.01 48 3.58 0.9 49 2.47 0.66 50 3.11 1.2 51 1.59 0.5 52 3.53 1.19 53 3.74 1.69 54 2.47 0.6 55 4.01 2.12 56 0.48 0.5 57 1.48 0.36 58 2.94 1.35 59 0.82 0.16 60 2.1 1 61 1.65 1.6 62 1.53 0.9 63 3 1.2 64 4.15 0.6 65 0.6 0.18 66 0.68 1.08 67 2.1 2.13 68 3.76 1 69 1.7 0.68 70 0.61 1.08 71 3.61 1.34 72 1.48 0.35 73 3.94 1.33 74 1.8 1.67 75 5.31 0.24 76 2.13 0.63 77 1.02 0.32 78 1.95 0.74 79 2.99 0.92 80 1.28 0.11 81 2.7 1 82 1.8 0.3 83 4.87 1.75 84 1.75 0.09 85 2.39 0.59 86 1.37 0.24 87 2.54 0.4 88 1.94 1.1 89 4.53 0.79 90 1.21 0.16 91 2.65 0.8 92 2.59 0.56 93 1.58 0.76 94 2.03 0.42 95 1.04 0.51 96 1.87 0.94 97 0.97 0.35 98 1.36 0.98 99 1.55 1.12 100 1.57

1

Explanation / Answer

Formula:

Company Earnings per Share earnings per share more than $2.00? Dividends per Share dividends per share between $1.00 and $2.00? 1 2.08 yes 0.22 no 2 2.08 yes 0.63 no 3 3.56 yes 0.36 no 4 0.08 no 0.6 no 5 2.19 yes 1.4 yes 6 1.01 no 0.34 no 7 2.76 yes 1.4 yes 8 1.14 no 2.8 no 9 3.8 yes 1.1 yes 10 5.41 yes 2.83 no 11 0.89 no 1.04 yes 12 1.06 no 1.13 yes 13 3.14 yes 1.52 yes 14 1.18 no 0.02 no 15 0.16 no 0.9 no 16 4.95 yes 2.28 no 17 4.88 yes 1.1 yes 18 1.59 no 1.8 yes 19 1.7 no 0.33 no 20 2.31 yes 0.16 no 21 2.15 yes 2.58 no 22 7.7 yes 3.24 no 23 1.2 no 0.91 no 24 2.08 yes 1.23 yes 25 3.63 yes 1.76 yes 26 1.73 no 1 no 27 0.33 no 0.38 no 28 1.03 no 1.8 yes 29 2.86 yes 0.2 no 30 0.71 no 0.5 no 31 3.37 yes 1.63 yes 32 3.57 yes 1.92 yes 33 1.3 no 0.2 no 34 2.39 yes 0.32 no 35 1.18 no 0.78 no 36 1.66 no 0.35 no 37 1.19 no 0.62 no 38 1.57 no 1.61 yes 39 1.4 no 0.54 no 40 3.18 yes 1 no 41 1.66 no 1.5 yes 42 3.47 yes 1.04 yes 43 2.41 yes 0.85 no 44 3.34 yes 0.77 no 45 0.79 no 0.48 no 46 0.21 no 1.96 yes 47 2.66 yes 1.01 yes 48 3.58 yes 0.9 no 49 2.47 yes 0.66 no 50 3.11 yes 1.2 yes 51 1.59 no 0.5 no 52 3.53 yes 1.19 yes 53 3.74 yes 1.69 yes 54 2.47 yes 0.6 no 55 4.01 yes 2.12 no 56 0.48 no 0.5 no 57 1.48 no 0.36 no 58 2.94 yes 1.35 yes 59 0.82 no 0.16 no 60 2.1 yes 1 no 61 1.65 no 1.6 yes 62 1.53 no 0.9 no 63 3 yes 1.2 yes 64 4.15 yes 0.6 no 65 0.6 no 0.18 no 66 0.68 no 1.08 yes 67 2.1 yes 2.13 no 68 3.76 yes 1 no 69 1.7 no 0.68 no 70 0.61 no 1.08 yes 71 3.61 yes 1.34 yes 72 1.48 no 0.35 no 73 3.94 yes 1.33 yes 74 1.8 no 1.67 yes 75 5.31 yes 0.24 no 76 2.13 yes 0.63 no 77 1.02 no 0.32 no 78 1.95 no 0.74 no 79 2.99 yes 0.92 no 80 1.28 no 0.11 no 81 2.7 yes 1 no 82 1.8 no 0.3 no 83 4.87 yes 1.75 yes 84 1.75 no 0.09 no 85 2.39 yes 0.59 no 86 1.37 no 0.24 no 87 2.54 yes 0.4 no 88 1.94 no 1.1 yes 89 4.53 yes 0.79 no 90 1.21 no 0.16 no 91 2.65 yes 0.8 no 92 2.59 yes 0.56 no 93 1.58 no 0.76 no 94 2.03 yes 0.42 no 95 1.04 no 0.51 no 96 1.87 no 0.94 no 97 0.97 no 0.35 no 98 1.36 no 0.98 no 99 1.55 no 1.12 yes 100 1.57 no 1 no

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.