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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
