The harmonic mean of a set of numbers is the number of scores N, divided by the reciprocals of each number. As an example, the harmonic mean of 7,8,7,3,6,2 is:
6 / (1/7 + 1/8 + 1/7 + 1/3 + 1/6 + 1/2) = 4.3
Design an Excel worksheet that allows the user the ability to enter up to 10 numbers and prints the harmonic mean of the numbers entered. Note: The user can enter from 1 and 10 different numbers inclusively.
Here is an example:
Harmonic Mean = 4.253165
| Numbers | Reciprocal |
| 7 | 0.142857143 |
| 8 | 0.125 |
| 7 | 0.142857143 |
| 3 | 0.333333333 |
| 6 | 0.166666667 |
| 2 | 0.5 |
Make your worksheet look like the following:
For a random number of selected homes sold in Washington County, the annual tax amount (in thousands of dollars) and selling price (in thousands of dollars) are as follows:
Taxes: 4.0 2.4 1.8 1.5 1.4 1.4 3.0 1.9Paste each of the following into a Word document.
Selling Price: 265 142 114 160 130 150 228 145
a) Perform a Linear Regression on the above data using Excel and SPSS.
b) What is the linear equation produced be performing the Linear Regression?
c) For an annual tax amount of $2,450, what might we expect the selling price of this house to be?
d) For a selling price of $235,000, what might we expect the taxes to be for this house?