A local game company is concerned their new product (designed for men) may be less interested in the coming months. They are specifically concerned young men are watching more TV than in previous years. Last year the average for men in the US was 14.35 hours per week. Use the results from the dataset to conduct a hypothesis solution to determine if men do watch more TV now. Use the 1% level of significance and the 5-Step process in a neatly formatted and well labeled spreadsheet. (Please show on Excel with the formulas needed.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

A local game company is concerned their new product (designed for men) may be less interested in the coming months. They are specifically concerned young men are watching more TV than in previous years. Last year the average for men in the US was 14.35 hours per week. Use the results from the dataset to conduct a hypothesis solution to determine if men do watch more TV now. Use the 1% level of significance and the 5-Step process in a neatly formatted and well labeled spreadsheet. (Please show on Excel with the formulas needed.)

Television Viewing Survey
Marital Status Age Gender Children in Home No. of TVs in Home Hrs of TV viewingper week Most Comonly Viewed Genre Method
Married 52
M
Action
Live
Drama
Live
Drama DVR
Drama DVR
CPU
Live
Sports Live
Sports
Live
Sports
Live
News
Live
Live
Live
DVR
Live
Live
Comedy
Live
Sports
DVR
Drama DVR
DVR
DVR
Sports
Live
Reality DVR
Drama Live
Sports Live
Comedy DVR
Single 46
Single 45
Single 48
Single 31
Single 41
Single 49
Married 40
Single 33
Single 42
Single 25
Married 29
Single 39
Single 49
Single 41
Single 45
Single 30
Married 50
Married 61
Single 32
Married 31
Married 28
Married 48
Married 33
Married 37
FFFMM
M
M
M
M
M
M
FFFFFFFFMEFMF
0
2
0
0
0
1
0
1
0
0031
1
0
0
0
1
0
0
0
0
1
3
3
334 WW NAGNA Awww T - WANANAW3w
4
2
4
2
4
1
4
3
3
3
4
4
2
5
4
2
3
3
6
40
16
15
10
15
12
16
35
21
650
152551
12
15
20
10
16
20
10
15
12
15
6
20
30
Sports
Comedy
Sports
Drama
Drama
Comedy
Drama
Drama
Drama
Transcribed Image Text:Television Viewing Survey Marital Status Age Gender Children in Home No. of TVs in Home Hrs of TV viewingper week Most Comonly Viewed Genre Method Married 52 M Action Live Drama Live Drama DVR Drama DVR CPU Live Sports Live Sports Live Sports Live News Live Live Live DVR Live Live Comedy Live Sports DVR Drama DVR DVR DVR Sports Live Reality DVR Drama Live Sports Live Comedy DVR Single 46 Single 45 Single 48 Single 31 Single 41 Single 49 Married 40 Single 33 Single 42 Single 25 Married 29 Single 39 Single 49 Single 41 Single 45 Single 30 Married 50 Married 61 Single 32 Married 31 Married 28 Married 48 Married 33 Married 37 FFFMM M M M M M M FFFFFFFFMEFMF 0 2 0 0 0 1 0 1 0 0031 1 0 0 0 1 0 0 0 0 1 3 3 334 WW NAGNA Awww T - WANANAW3w 4 2 4 2 4 1 4 3 3 3 4 4 2 5 4 2 3 3 6 40 16 15 10 15 12 16 35 21 650 152551 12 15 20 10 16 20 10 15 12 15 6 20 30 Sports Comedy Sports Drama Drama Comedy Drama Drama Drama
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman