EXCEL 2 – Math

Excel 2 Online Please save file as First Last Name Excel 2. Also make sure your name is in cell A1. 1. You inherited $1000 and plan to deposit it into a Money Market account with an APR of 8%. Find the balance for the first five years if the interest is compounded. Predict when all of the accounts will double (i.e. reach $2000) a. Set up a table with 4 columns. Label columns as Year, Monthly, Quarterly, Continuously. Use years 1-5. Use the correct formula to fill out the compound interest amounts. Be sure your columns are in currency format. b. Monthly c. Quarterly d. Continuously e. Predict when the account will double for all accounts. 2. Enter the following data and create a scatter plot. The following table shows the wind speed and the corresponding wind chill factor when the air temperature is 10°F. Wind Speed (mi/h) Wind Chill Factor °F 4 3 5 1 12 -5 16 -7 22 -10 31 -12 a. Find the logarithmic regression of the wind chill factor as a function of wind speed. b. Create a new row to show predictions for wind chill from the regression model. c. Predict wind chill for 35 mph wind. Interpret your answer in a complete sentence. d. Predict the wind speed if the wind chill factor is -5°F on a 10°F day. Interpret your answer in a complete sentence. 3. Enter the following data and create a scatter plot. The following table shows the immigrant population of the United States as recorded from census data. Years since 1980 Population in millions 0 5.31 10 7.24 20 9.64 30 12.87 40 17.07 50 23.19 60 31.44 a. Create a new row to find the ratio of population values. b. What do the ratios of population values suggest about the data. c. Find the exponential regression of population as a function of years since 1980. d. Create a new row to show predictions for population from the regression model. e. Predict the population in 2020. Interpret your answer in a complete sentence. f. Predict year when population reaches 38 million. Interpret your answer in a complete sentence.