A market researcher is studying on-line subscription services. She is particularly interested in what variables relate to the number of subscriptions for a particular on-line service. She is able to obtain the following sample information on 25 on-line subscription services. The following notation is used: Sub = Number of subscriptions (in thousands) Web page hits = Average monthly count (in thousands) Adv = The advertising budget of the service (in $ hundreds) Price = Average monthly subscription price ($) Web Page Hits Web Page Hits Service Adv Price Price 35.1 Service Sub Adv Sub 586.5 544.0 35.5 34.9 13.2 14 38.39 15.4 37.95 37.66 1. 588.9 585.3 13.2 34.7 15 37.29 11.0 37.55 566.3 19.8 34.8 16 39.15 611.1 24.2 35.0 643.3 17.6 35.3 642.9 624.2 603.9 4 38.78 17.6 35.1 17 38.29 34.8 635.6 598.9 37.67 17.6 34.6 18 38.09 19.8 15.4 35.1 15.4 11.0 38.23 34.8 19 37.83 657.0 22.0 35.3 36.90 38.28 571.9 584.3 34.7 20 39.37 35.1 35.3 35.1 8. 28.6 21 37.81 595.2 15.4 520.0 629.6 35.1 35.3 9. 38.95 605.0 28.6 22 37.42 19.8 10 39.27 676.3 17.6 35.6 23 38.83 22.0 34.7 35.8 11 38.30 587.4 17.6 34.9 24 38.33 680.0 24.2 35.4 25 40.24 651.2 33.0 38.84 38.14 12 576.4 22.0 13 570.8 17.6 35.0 B Click here for the Excel Data File a. Determine the regression equation. (Negative value should be indicated with a minus sign. Round your answers to 4 decimal places.) X1 + X2 X3 b. Conduct a global test of hypothesis to determine whether any of the regression coefficients are not equal to zero. Use a = 0.05. (Round your answers to 2 decimal places.)

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

I need help with A and B I have 2 hours and 30minutes to finish this

ere for the Excel Data File
a. Determine the regression equation. (Negative value should be indicated with a minus sign. Round your answers to 4 decimal
places.)
X2 +
X3
b. Conduct a global test of hypothesis to determine whether any of the regression coefficients are not equal to zero. Use a =
0.05. (Round your answers to 2 decimal places.)
Ho: B1 = B2 = B3 = 0
H: Not all B;'s = zero.
Reject Ho if F>
at least one
of the independent variables matter(s).
The null is
rejected
in favor of the alternative,
< Prev
5 of 10
Next >
MacBook Air
411
出

A market researcher is studying on-line subscription services. She is particularly interested in what variables relate to the number of
subscriptions for a particular on-line service. She is able to obtain the following sample information on 25 on-line subscription services.
The following notation is used:
Sub = Number of subscriptions (in thousands)
Web page hits = Average monthly count (in thousands)
Adv = The advertising budget of the service (in $ hundreds)
Price = Average monthly subscription price ($)
Web Page
Web Page
Hits
588.9
585.3
566.3
642.9
624.2
Service
Sub
Adv
Price
Service
Sub
Hits
Adv
Price
37.95
13.2
35.1
14
38.39
586.5
15.4
35.5
37.29
544.0
11.0
34.9
37.66
37.55
38.78
37.67
13.2
34.7
15
3
19.8
34.8
16
39.15
611.1
24.2
35.0
35.3
38.29
38.09
37.83
4
17.6
35.1
17
643.3
17.6
34.8
34.6
34.8
5.
17.6
635.6
19.8
15.4
35.1
603.9
571.9
584.3
6.
38.23
15.4
19
598.9
657.0
595.2
22.0
15.4
19.8
36.90
11.0
34.7
20
39.37
35.3
8.
38.28
28.6
35.3
21
37.81
35.1
520.0
629.6
38.95
605.0
28.6
35.1
22
37.42
35.1
22.0
24.2
35.3
34.7
38.83
676.3
587.4
10
39.27
17.6
35.6
23
38.30
17.6
34.9
24
38.33
680.0
11
40.24
651.2
33.0
35.8
35.4
35.0
12
38.84
576.4
22.0
25
13
38.14
570.8
17.6
D Click here for the Excel Data File
a. Determine the regression equation. (Negative value should be indicated with a minus sign. Round your answers to 4 decimal
places.)
X1+
X2
X3
b. Conduct a global test of hypothesis to determine whether any of the regression coefficients are not equal to zero. Use a =
0.05. (Round your answers to 2 decimal places.)
< Prev
5 of 10
Next >
MacBook

Expert Solution

Step 1

Here we use Excel to determine the regression equation. Steps to perform regression analysis in Excel;

Enter the data into a spreadsheet

Go to Data>Data Analysis>Regression>OK
Select the Sub column for Y-range and Web Page Hits, Adv and Price columns for X-range.
Check Labels>OK
The obtained result is;

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Point Estimation, Limit Theorems, Approximations, and Bounds$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions