Questions -
Q1. Looking at Vlookupexample1.xlsx put the company name of the Equity on the tab titled "Securities Code." Summarize in a pivot table the closing average price by primary exchange.
Q2. An air conditioning and heating repair firm conducted a study to determine if the outside temperature could be used to predict the cost of an electric bill for homes during the winter months in Houston, TX. The resulting regression equation was: Y= 227.19-1.45X, where Y = monthly cost, X= outside air temperature.
a. If the temperature averaged 45 degrees during December, what is the forecasted cost of December's electric bill?
b. If the temperature averaged 40 degrees during January, what is the forecasted cost of January's electric bill?
c. Can you use the Electric bill cost to predict what the average temperature in a month? Why or Why not?
Q3. A large international sales organization has collected data on the number of employees and the annual gross sales during the last seven years. Determine
|
Numb of Employees
|
Sales (in $000's)
|
|
1975
|
78
|
|
2010
|
115
|
|
2005
|
122
|
|
2020
|
135
|
|
2035
|
138
|
|
2045
|
160
|
|
2050
|
186
|
|
2070
|
202
|
A. Make a scatter diagram
B. Make a regression line
C. What is the R square for this? What does it tell you?
a. Is it significant?
D. What is the coefficient of correlation?
E. What is the regression equation?
F. What are the expected sales for 2068 employees?