Exam #2
NOTE: You may use your class notes, homework assignments and tutorials or referenced web site for information to complete this test. USE KALEIDAGRAPH TO ASNWER ALL THE QUESTIONS
1.Open a MS Word and type all of your answers on this page.
2. Please make sure to write down the question number in front of your answer.
3.Don’t forget to write your name and today’s date.
(21 PTS) QUESTIONS 1
Temperature and the Periodic table
Temperature (T) Thermal conductivity (K) Elements
1.
250. 0.445 Li
300 0.362 Na
350 0.302 K
400 0.256 Rb
450 0.223 Cs
500 0.197 Fr
550 0.176 Be
600 0.158 Mg
650 0.144 Ca
700 0.132 Sr
750 0.121 Ba
800 0.112 Ra
850 0.103 Al
2. Construct a bar graph using thermal conductivity (K) on y axis and temperature data on x axis. Make sure to include title. Label Axis.
3. Construct a scatter plot of temperature (T) vs thermal conductivity (K)and determine the equation of the line of best fit and X error bar to the graph. Past the graph with error bars and equation of the line to your word page. An element has a thermal conductivity of 0.85 what will be its temperature?
c. Generate statistics data for both temperature and thermal conductivity
d. In a new column calculate conductivity x 150.
e. Construct a column graph with the elements on the x axis and the Temperature and thermal conductivityx250 on the y axis.
f. Define a new column which is 3*(1/Temperature) + 250*K
g. Define a new column in which is 4.20*(1/Termal Conductivity) + 150
(24PTS) QUESTION 2
The accompanying table shows the life expectancy of a male and female child born in various years in the US
Male Female
1970 67.1 74.7
1975 68.8 76.6
1980 70 77.4
1985 71.1 78.2
1990 72.5 78.9
1995 74.3 79.7
2000 74.3 79.7
2005 75.2 80.4
h.
pppppppppp. Find the mean for life expectancy for male
qqqqqqqqqq. Find the mean for life expectancy for female
rrrrrrrrrr. Find the sum of all males ages
ssssssssss. Find the sum of all females ages
tttttttttt. What is min for male age? Min for female age?
uuuuuuuuuu. What is max for male age? Max for female age?
vvvvvvvvvv. Plot a bar graph showing years in x-axis and both male and female ages on y-axis
wwwwwwwwww. Plot a box plot for each male and female
xxxxxxxxxx. What are the values of Q1, Q2 and Q3 for each male and female?
yyyyyyyyyy. What are the z scores for.67.1 and 75.2 males; 78.2 and 80.4 female?
(8 PTS) QUESTIONS 3
The following table shows the number of people in the U.S. living in various years.
Year Number with AIDS
1999 311,205
2000 334,731
2001 357,040
2002 380,771
2003 405,926
a. Plot a scatter graph for these data. X axis year, y-axis AIDS
b. Fit the data to a straight line. Show the equation of the line and x error bars.
c.Use the equation of the line to estimate the total number of people living with AIDS in 2021.
(7 PTS) QUESTIONS 4
Major uses of copper: Make a pie chart and line chart for the percentages. Which graph display the information most meaningfully?
Building construction 4%
Electrical/electronic products 23%
Consumer products 11%
Transportation products 10%
Industrial machinery 9%
(14 PTS) QUESTIONS 5
Education and Income
Name Education Income GPA Age
Tom 11 23500 2.8 26
Mike 12 27300 2.9 32
Amy 11 27900 3 28
Sue 16 30500 3.2 27
Barb 16 27300 3.9 25
George 13 31500 3.0 33
Mark 20 32300 3.1 33
Phil 20 34700 3.6 33
Mary 16 30500 3.8 29
Jan 14 31500 4.0 23
1. Plot a double y graph (y1y2) using Name for x and Y1 education and Y2 income
2. Plot a column graph with name in x axis and GPA and age in y axis.
3. Plot a scatter graph with income vs age. Do an appropriate fit for the data and show the equation of the fit.
4. Calculate the average of education
5. Calculate the average of GPA
6. Calculate the sum of all income
7. Calculate the sum of all ages
8. In another new column calculate ln(income)
(12 PTS) QUESTIONS 6
Advertising and Income
Advertising
($10,000’s) Income
( $100,000’s)
12 31
14 38
16 47
15 42
13 37
19 51
a. Create a scatter plot of the data with advertising in the x-axis and Income y-axis
b. Apply a linear regression (linear curve fit). Show the equation of the line
c. What is the predicted Income if Advertising is $350,000?
d. Does the Income tend to increase with increased expenditure on Advertising, as one might hope?
e. Why is it useful to create a scatter plot as part of linear regression?
(14 PTS) QUESTIONS 7
Elizabeth Lunch
Menu Item Pizza (g) Taco Salad(g) Grape Soda (g)
Carbohydrate 39.8 26.6 41.7
Protein 20.2 17.4 0
Saturated Fat 4.4 6.0 0
Polyunsatured fat 2.4 1.5 0
Monounsaturated Fat 6.2 4.5 0
Cholesterol 0.028 0.055 0
h. Construct a bar graph using menu items on x axis and pizza and taco salad on the y axis. Make sure to include title. Label Axis.
i. Construct a double-y graph, with menu items on the x-axis and Y1 Pizza, Y2 Taco Salad
j. Construct a column graph with menu item on the x axis and pizza on y axis.
k. Generate statistics data for both pizza and Taco Salad.
l. In a new column calculate the average grams intake between the pizza and Taco salad
m. In a new column calculate Pizza * 15%
n. In a new column calculate Taco Salad * 85%
o. In a new column calculate Pizza*15% + Taco Salad*85%