non linear equation solver unknowns equations ,   free worksheet solving addition and subtraction equations , graph equation basic algebra help , simplifying exponential expressions variable in the exponent ,   basic algebra power fraction ,   How to solve Non linear Equation solving,     algebra help calculate greatest common denominator,   solving 3rd order quadratic equations , sqare roots of integer number , rational expressions on-line calculator ,   free simultaneous quadratic equation solver, first order linear partial differential equation solutions ebook ,     algebra easy finding greatest common denominator  
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 best-fitting 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 double-clicking 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 best-fit 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 best-fit 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

 

• Home
• Why Algebrator?
• Guarantee
• Testimonials
• Comparison
• Try Our Demo!
• Order
• Who We Are
• FAQs
• Resources
• Privacy