CS130 Intro to Software Tools

Midterm Handson Review

Problem 1 (Easy):

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.9  
Selling  Price:  265  142  114  160  130  150  228  145  

a) Enter the above information into an Excel worksheet.

b) Perform a Linear Regression on the data with your graph properly labeled and displaying the linear equation and R^2 value.

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?

Problem 2 (Easy):

The first few fibonacci numbers are: 1,1,2,3,5,8,... where the first two numbers are always 1,1 and each subsequent number is found by adding the previous two. In one column, I would like you to find the first 12 fibonacci numbers. In another column, I would like you to find the first 12 solutions to the equation: y=x^2 over the interval 1<=x<=12 where x is an integer. Once you have these two columns laid out, show the graph of each set of numbers with all axes properly labeled and a chart title.

Challenge (Hard): You can only use two columns of data to solve Problem 1.

Problem 3 (Hard):

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        

Make your worksheet look like the following:

Remember, you have two more problems in your notes that you need to work through before the exam. Please see me if you have any questions.