SLOPE FORMULA, QUADRATIC FORMULA, SLOPE INTERCEPT FORMULA SHEET
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