Your browser does not support JavaScript! Really?
header logo
52 West Main Street
Washingtonville, NY 10992

Phone: 845.497.4000
Fax: 845.497.4030
Salary Functions

You will need use Excel to graph how much money you would make per month for 3 years. Assume you do not have to pay taxes.  When you are done print out all four graphs and then answer the questions on the following pages.  

 
Salary: You are paid $50,000 a year.
Hourly: You are paid $8.25 an hour and you work a different number of hours each month ranging from 80 hours - 160 hours a month. Below you will find the numbers of hours you work each month.
Commission: You will be making 3% of your sales. Below you will find how much you have sold per month.
Tips: You make $2.13 per hour plus tips. Below you will find the number of hours and how much tips you have received each month. 
Salary Functions Downloads
Sport Teams
NBA/MLB/NFL/NHL- pick any two stats and compare them, you must have at least 20 things in your data. Try to pick things that you think are correlated such as minutes/points, salary/wins, QB rating/wins, or homeruns/RBI’s.

Make a table of values using excel and then create a scatter plot. On the graphing calculator find the correlation coefficient (round to the nearest hundredth) and linear regression equation (round to the nearest thousandth).
 
For the second graph you must pick a different sport.
Comparison of States
You will need to pick two topics from www.statemaster.com and see if they are correlated. You must include at least 20 states. Make sure you match up the states data points. You are allowed to pick any two topics but please try to pick two that you think may actually have a correlation such as poverty vs. violent crime. Once you have your data you must enter it into EXCEL to create a graph.

Make a table of values using excel and then create a scatter plot. Find the correlation coefficient (round to the nearest hundredth) and linear regression equation (round to the nearest thousandth).
Equation of Lines
Watch the following lesson:
The play the following game (you must get 2000 points):
Finally, do the 2-16 evens from the following website:
© 2017. Washingtonville Central School District. All Rights Reserved.
52 West Main Street Washingtonville, NY 10992  |  Phone: 845.497.4000  |  Fax: 845.497.4030
View text-based website