Description
1. 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 degrees Fahrenheit. (a) Is the wind chill factor increasing or decreasing as wind speed increases? Is the rate of change constant, increasing, or decreasing? (b) Find the logarithmic regression of the wind chill factor as a function of wind speed. Include the equation and trendline on your scatterplot. (c) Predict wind chill for 40 mph wind. Interpret your answer in a complete sentence. (d) Predict the wind speed if the wind chill factor is −3 degrees Fahrenheit. Interpret your answer in a complete sentence. 2. 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. (a) Is the population increasing or decreasing as the years pass? Is the graph concave up or concave down? (b) Create a new row to find the ratio of population values. (c) What do the ratios of population values suggest about the data? (d) Predict the population in 2015. Interpret your answer in a complete sentence (it may be helpful to create a regression of some sort; if so, include the equation on the graph with the scatterplot). 1 (e) Predict the year when population reaches 32 million. Interpret your answer in a complete sentence. 3. You inherited 1000 dollars and plan to deposit it into a Money Market account with an APR of 8 percent. Find the balance for the first five years if the interest is compounded yearly, monthly, daily and continuously. (To do this, set up a table with 4 columns. Label columns as Year, Monthly, Daily, Continuously. Use years 1 to 5 as your rows. Use the correct formula to fill out the compound interest amounts. Be sure your columns are in currency format, i.e. only up to two decimal places.) 4. For how many years must you invest 850 dollars at an annual rate of 3.9 percent, compounded quarterly, in order to have 5000 dollars in the account? Interpret your answer in a complete sentence. 5. Alice deposits 500 dollars into a savings account earning 4.5 percent interest compounded annually. Bob deposits 800 dollars into an account earning 3 percent interest compounded annually. When will the balances be equal? (Below are steps that walk you through finding the answer.) (a) Set up a table with 3 columns. Label columns as Year, Alice, and Bob. (b) Fill in Year with years from 0 to 40 (using a formula). You must include years 0, 5, 10, 15 . . . , 40, but you can include more if you like. (c) Use the correct formula for compound interest to fill in both the remaining columns (in currency format, i.e. up to two decimal places). (d) Create a fourth column labeled Difference. Use a formula to calculate the difference between the accounts at a certain year. (e) Use goal seek to find when the balances will be equal. Interpret your answer in a complete sentence.
Explanation & Answer
Here is my answer :)
Excel 1 - Last Name, First Name
Problem 1
Wind Speed (mph)
Wind Chill Factor (degrees F)
4
3
5
1
a.
No, the wind chill factor is decreasing
b.
See the Scatterplot
12
-5
16
-7
22
-10
b. Logarithmic Regression
4
2
0
-2 0
5
10
15
20
25
-4
-6
-8
-10
y = -7.313ln(x) + 13.013
-12
-14
c.
Wind Speed =
40 [mph]
Wind chill factor =
-13.96 [degrees F]
The wind chill factor will be -13.96 F for a wind speed of 40 mph.
d.
Wind chill factor =
-3 [degrees F]
Wind Speed =
8.93 [mph]
To obtain a wind chill factor equal to -3 F it is necessary apply a wind speed 8.93 mph
Problem 2
Years since 1980
Population in Millions
a.
0
5.31
10
7.24
20
9.64
30
12.87
40
17.07
Yes, the populat...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Nervous Conditions
by Tsitsi Dangarembga
The Old Man and the Sea
by Ernest Hemmingway
The Picture of Dorian Gray
by Oscar Wilde
Notes from Underground
by Fyodor Dostoyevsky
Killers of the Flower Moon
by David Grann
Fear - Trump in the White House
by Bob Woodward
Dracula
by Bram Stoker
Steppenwolf
by Hermann Hesse