Math Project

MTH 154 EXCEL COURSE PROJECT

1. Using Excel, calculate and graph the function y = x^2 + 2x in the interval [xmin = -3, xmax = 3], with a step h = 0.25. Please, show all necessary work.

What is the minimum value of the function?

2. For a dataset: 1, 3, 5, 2, 6, 8, 5, 9, 13, 10, 16, 12, 11, 15, 17, find the standard deviation using (a) Excel statistical functions

(b) the formula S = SQRT[(1/(n-1))*SUM(i=1,n)[(xi – x-bar)^2]

3. Construct a histogram for the frequency table

CLASS| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |

----------|-------|-------|-------|-------|-------|------|------|------|------|

FREQ | 10 | 20 | 30 | 70 | 60 | 50 | 30 | 20 | 10 |

What can be concluded on the population distribution from the histogram?

4. Social Security expenditures (SSE, in billions) in the U.S. are shown in the table:

YEAR 1980 1985 1990 1995 2000 2005 2010 2015 2020

SCE 64.65 118.55 188.62 248.62 335.85 409.42 523.31 706.74 813.55

Graph the data and construct a linear regression line for the data.

What is an expected SSE value for 2023? for 2025?

5. Calculate and graph the function y = 10*1.2^t - 5 at the interval [tmin = 0, tmax=10] with a step h = 0.5. Please, show all necessary work. What is the function value at t = 3? t = 5?

INSTRUCTIONS HOW TO SUBMIT CP

1. CP is performed in EXCEL following the models I teach you in our classes

2. ON TOP of the Excel-file write YOUR NAME

3. Name the file 1=CP=John Smith

4. Send the ready CP-file to [email protected]

5. The deadline is 06/22/20. No paper will be accepted after 11.59 of 06/22.