Question
In: Statistics and Probability
#2) Use computer software packages, such as Excel, to solve this problem. Consider the following data...
#2) Use computer software packages, such as Excel, to solve this
problem.
Consider the following data for a dependent variable y and two
independent variables, x1 and x2.
|
x1 |
x2 |
y |
|
30 |
12 |
95 |
|
46 |
11 |
108 |
|
24 |
18 |
113 |
|
51 |
16 |
178 |
|
40 |
6 |
94 |
|
52 |
19 |
175 |
|
74 |
8 |
170 |
|
36 |
12 |
117 |
|
60 |
14 |
142 |
|
77 |
17 |
211 |
a) If you ran a multiple regression model using both independent variable what would the p-value of the overall model be? Round to 3 decimals. Is the overall model significant at the ? = 0.01 level?
b) What percent of the variation in y is explained by the model? Round to the nearest percent.
c) If you ran a multiple regression model using both independent variable what would the individual p-value of x1 be? Round to 3 decimals. Is x1 significantly adding to the overall model at the ? = 0.01 level?
d) If you ran a multiple regression model using both independent variable what would the individual p-value of x2 be? Round to 3 decimals. Is x2 significantly adding to the overall model at the ? = 0.01 level?
Solutions
orchestra answered 1 year agoRelated Solutions
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to
solve this problem.
The owner of Showtime Movie Theaters, Inc., would like to
predict weekly gross revenue as a function of advertising
expenditures. Historical data for a sample of eight weeks
follow.
Weekly
Television
Newspaper
Gross Revenue
Advertising
Advertising
($1,000s)
($1,000s)
($1,000s)
101
5.0
1.5
90
2.0
2.0
95
4.0
1.5
92
2.5
2.5
96
3.0
3.3
94
3.5
2.3
94
2.5
4.2
101
3.0
2.5
a. Develop an estimated...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to
solve this problem.
The owner of Showtime Movie Theaters, Inc., used multiple
regression analysis to predict gross revenue (y) as a function of
television advertising (x1) and newspaper advertising (x2). Values
of y, x1, and x2 are expressed in thousands of dollars.
Weekly Gross Revenue ($1000s)
Televison Advertising ($1000s)
Newspaper Advertising ($1000s)
96
5
1.5
90
2
2
95
4
1.5
92
2.5
2.5
95
3
3.3
94
3.5
2.3...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to
solve this problem.
The owner of Showtime Movie Theaters, Inc., would like to
predict weekly gross revenue as a function of advertising
expenditures. Historical data for a sample of eight weeks
follow.
Use computer software packages, such as Minitab or Excel, to
solve this problem.
The owner of Showtime Movie Theaters, Inc., would like to
predict weekly gross revenue as a function of advertising
expenditures. Historical data for a sample...
#1) Use computer software packages, such as Excel, to solve this problem. The owner of Showtime...
#1) Use computer software packages, such as Excel, to solve this
problem. The owner of Showtime Movie Theaters, Inc., would like to
predict weekly gross revenue as a function of advertising
expenditures.
Weekly Gross Revenue ($1,000s)
Television Advertising ($1,000s)
Newspaper Advertising ($1,000s)
105
5.0
1.5
90
2.0
2.0
95
4.0
1.5
92
2.5
2.5
93
3.0
3.3
94
3.5
2.3
94
2.5
4.2
a) Develop an estimated regression equation with the amount of
television advertising as the independent variable (to...
Use computer software packages, such as Excel, to solve this problem. The Jacobs Chemical Company wants...
Use computer software packages, such as Excel, to solve this
problem.
The Jacobs Chemical Company wants to estimate the mean time
(minutes) required to mix a batch of material on machines produced
by three different manufacturers. To limit the cost of testing,
four batches of material were mixed on machines produced by each of
the three manufacturers. The times needed to mix the material
follow.
Manufacturer 1
Manufacturer 2
Manufacturer 3
17
29
17
23
27
16
21
32
20...
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using
excel:
1
a) Import the data into an Excel file.
Done!
b) Create a new column in the spreadsheet to assign the category
of each car according to
the engine horsepower. For this exercise use IF statements in
each cell to determine the
class for each vehicle.
i. Class 1 if the vehicle horsepower is less than 80 HP.
ii. Class 2 if the vehicle horsepower is between 81 and...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...
(PLEASE READ ) :)
Use the data below to solve the following problem using excel: (
I would like to know how do you input the formula for each
category, so please explain the process)
I will RATE and comment your answer accordingly
1
a) Import the data into an Excel file.
Done!
b) Create a new column in the spreadsheet to assign the category
of each car according to
the engine horsepower. For this exercise use IF statements in...
The following data pertains to On-Target Investment Accounting software packages in the inventory of Computer Program...
The following data
pertains to On-Target Investment Accounting software packages in
the inventory of Computer Program On-Target Outlets:
Inventory, January 1
190
units at
$111
Purchases:
May 10
130
units at
$109
August 18
200
units at
$108
October 1
190
units at
$109
Inventory, December 31
199
units
1(a)
Determine the cost of
the inventory on December 31 and the cost of goods sold for the
year ending on that date under the FIFO method.
1(b)...
THIS PROBLEM NEEDS TO BE SOLVED ONLY USING EXCEL SOFTWARE! 1. Use the following data set...
THIS PROBLEM NEEDS TO BE SOLVED ONLY USING EXCEL
SOFTWARE!
1. Use the following data set to answer the following:
ew
dbh
e
23.5
e
43.5
e
6.6
e
11.5
e
17.2
e
38.7
e
2.3
e
31.5
e
10.5
e
23.7
e
13.8
e
5.2
e
31.5
e
22.1
e
6.7
e
2.6
e
6.3
e
51.1
e
5.4
e
9
e
43
e
8.7
e
22.8
e
2.9
e
22.3
e
43.8
e
48.1
e
46.5
e
39.8...
USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...
USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL
CALCULATIONS AND FORMULAS.!!!
Find the data for the problem in the first worksheet named
LightbulbLife of the data table down below It gives the data on the
lifetime in hours of a sample of 50 lightbulbs. The company
manufacturing these bulbs wants to know whether it can claim that
its lightbulbs typically last more than 1000 burning hours. So it
did a study.
Identify the null and the alternate hypotheses for...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- closed
- Discuss the major differences of European welfare states and the American welfare state? What is the...
- How does gene expression initiate? What are the key steps in gene expression?
- If you owned your own business with a staff of 150 what would be the three...
- 1 a) Determine the enthalpy change for the following reaction under standard conditions and 25 °...
- You are standing 2.50m directly in front of one of the two loudspeakers shown in the...
- What's the objective of precursor preparation experiment? And why the color of precursors changes during the...
ADVERTISEMENT