Try our Free Online Math Solver!

Thank you for visiting our site! You landed on this page because you entered a search term similar to this: slope formula, Quadratic formula, slope intercept formula sheet. We have an extensive database of resources on slope formula, Quadratic formula, slope intercept formula sheet. Below is one of them. If you need further help, please take a look at our software "Algebrator", a software program that can solve any algebra problem you enter!
Average Monthly Expenses 

1990 
1991 
1992 
1993 
1994 
1995 

Rent/House Payments 
550 
570 
580 
620 
630 
670 
Utilities 
65 
72 
83 
75 
72 
75 
Food 
160 
180 
185 
195 
220 
225 
Transportation 
230 
227 
223 
215 
215 
205 
Entertainment 
35 
35 
40 
42 
42 
45 
2. Find the slope of a line fitted to each type of expense, to see how that expense changed during the time period 1990 through 1995. To find the slope for Rent/House Payments, position the cursor in, say, cell H4 and type =SLOPE(B4:G4,B3:G3). The slope of the bestfitting line will be displayed. Cursor to cell H5 and similarly type =SLOPE(B5:G5,B3:G3). Notice that the first cell range denotes the expenses and the second cell range denotes the year. Continue to find these slopes for all the five types of expenses.
If you have had some experience with cutting and pasting Excel formulas, you could type =SLOPE(B4:G4,B$3:G$3) in cell H4 and then copy this formula to cells H5 through H8.
Average Monthly Expenses 

slope 

1990 
1991 
1992 
1993 
1994 
1995 

Rent/House Payments 
550 
570 
580 
620 
630 
670 
23.42857 
Utilities 
65 
72 
83 
75 
72 
75 
1.2 
Food 
160 
180 
185 
195 
220 
225 
13 
Transportation 
230 
227 
223 
215 
215 
205 
4.82857 
Entertainment 
35 
35 
40 
42 
42 
45 
2.085714 
The slope indicates approximately how much the expenses are increasing or decreasing per year. For example Rent/House Payments increased approximately $23.43 per year. Transportation decreased approximately $4.83 per year.
3. Now make a graph showing how all these expenses changed between 1990 and 1995.
Highlight cells B3 through G8 and click on the graph icon. Choose XY(Scatter) and then click on the fourth subtype picture "Scatter with data points connected by lines." Then click Next.
Click on the Series Tab and type in the names of the five types of expenses. Click Next.
Click on the Titles tab and type "Monthly Expenses" for the Chart Title. Type "Year" for the Value(X)Axis and "Dollars" for the Value(Y)Axis. Click Next.
Click on As Object in and then click Finish. You can move or resize your graph as you wish. By clicking or doubleclicking on any part of your graph, you can change the size, font, placement, etc. of that part. Your final graph should look similar to the following graph.
4. You can choose to graph only some of these expenses. For example, suppose you want the graph to show only Utility and Entertainment expenses. Highlight cells B3 through G3. Then hold down the Ctrl key and highlight cells B5 through G5. Next hold down the Ctrl key again and highlight cells B8 through G8. (All three of these rows should now be highlighted.) Next click on the graph icon and proceed as before. Your graph should look something like this:

Nuclear Energy Activity Worksheet 
Name ____________________ 
1. (3 points) Access the site and search for Nuclear Capacities. Find the table giving Historical and Projected Operable Nuclear Capacities by Region.
2. (3 points) Name three countries whose projected nuclear capacities are increasing over the next twenty years.
3. (3 points) Name three countries whose projected nuclear capacities are decreasing over the next twenty years.
4. (3 points) You should now copy Table 1 to your spreadsheet. Click and highlight the whole table, then click on Edit and then on Copy. Next open your spreadsheet. Click on cell A1, then click on Edit and then on Paste. All the data from Table 1 should now be transferred to the spreadsheet into columns A through G.
5. (12 points) Calculate the slope of the bestfit line for the data of each of your six countries. You might record this data in Column I. In Excel, for example, if the Country A data were in row 12, and since the years are in row 3, you would position the cursor at cell I1 and then type the command
= SLOPE(B12:G12,B3:G3)
COUNTRY 
SLOPE 
__________________________________ 
______________ 
__________________________________ 
______________ 
__________________________________ 
______________ 
__________________________________ 
______________ 
__________________________________ 
______________ 
__________________________________ 
______________ 
6. (15 points) Make a scatterplot with the data connected by line segments for these six countries. Print out a copy of your spreadsheet.
7. (5 points) Which of these six countries will be increasing their nuclear power the fastest? What is the "rate of change" of nuclear power in this country? Interpret this value.
8. (5 points) Which of these six countries will be decreasing their nuclear power the fastest? What is the "rate of change" of nuclear power in this country? Interpret this value.
9. (5 points) Which of these six countries has the smallest "rate of change" of their nuclear capacity? Explain why. What is this rate of change?
10. (5 points) In the year 2020, which of these six countries will be producing the most nuclear power? Which will be producing the least?
11. (5 points) Look at your original table with all the data for all the countries. In the year 2020, which country will be producing the most nuclear power? Which will be producing the least?
12. (5 points) Is there any country for which the rate of change of its nuclear power production is zero? Describe this countrys production.

Nuclear Energy Activity Worksheet (Sample Answers)
1. (3 points) Access the site and search for Nuclear Capacities. Find the table giving Historical and Projected Operable Nuclear Capacities by Region.
2. (3 points) Name three countries whose projected nuclear capacities are increasing over the next twenty years.
India, China, Japan
3. (3 points) Name three countries whose projected nuclear capacities are decreasing over the next twenty years.
United States, Bulgaria, Germany
4. (3 points) You should now copy Table 1 to your spreadsheet. Click and highlight the whole table, then click on Edit and then on Copy. Next open your spreadsheet. Click on cell A1, then click on Edit and then on Paste. All the data from Table 1 should now be transferred to the spreadsheet into Columns A through G.
Data for the above countries:
1996 
2000 
2005 
2010 
2015 
2020 

US 
100817 
95605 
86800 
80357 
63881 
49217 
Bulgaria 
3538 
3538 
2722 
2722 
1906 
1906 
Germany 
22282 
21063 
20083 
16120 
11800 
5250 
India 
1695 
2503 
3103 
5913 
7640 
9890 
China 
2167 
2167 
6737 
11542 
14700 
18760 
Japan 
42369 
43525 
44321 
47526 
53623 
54107 
5. (6 points) Calculate the slope of the bestfit line for the data of each of your six countries. You might record this data in Column I. In Excel, for example, if the Country A data were in row 12, , and since the years are in row 3, you would position the cursor at cell I1 and then type the command
= SLOPE(B12:G12,B3:G3)
COUNTRY United States Bulgaria Germany India China Japan 
SLOPE 2123.39 76.99 692.17 349.74 740.91 544.99 