UNC Chapel Hill Math 119 Scatter Plot Excel Project

User Generated

Tyvmml301

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags