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 2 years 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...
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package...
this is in excel VB8
Program 2: Software Sales A software company sells three
packages, Package A, Package B, and Package C, which retail for
$99, $199, and $299, respectively. Quantity discounts are given
according to the following table: Quantity Discount 10 through 19
20% 20 through 49 30% 50 through 99 40% 100 or more 50% Create an
application that allows the user to enter the number of units sold
for each software package. The application should calculate and...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In MATLAB: (a) Insert a comment in your script that says Problem 1: (b) Below this...
- C++ Build a struct with many data members inside (for example, a large array). Design any...
- I wrote a c++ program that is suppose to calculate the interest on a CD account...
- also well known in the housing estate industry. Its products include household furniture, office furniture and...
- Make a program to perform Heap Sort, must run in Alice programming only. Only correct answers...
- Unique Furniture Limited is one of the leading producers of wood furniture in Ghana and is...
- Discussion Have you ever witnessed an emergency situation? Did you intervene or were you a bystander?...
ADVERTISEMENT