Description
Homework-9
All problems are from the Levine - Text-Book - Edition 8
For this HW you can use EXCEL Functions, DATA ANALYSIS TOOL-PAK (Add-in) OR PHstat
Chapter 10 : Problem Numbers 10-9, 10-21, 10-23
Excel files attached
Submission:
This assignment can be done by any one of the alternatives listed below.
- Do it manually on paper/pencil... scan and attach as 1 pdf document
- Use excel - charts and simple EXCEL calculations and attach 1 excel workbook (each problem on separate worksheet)
- Use Analysis Toolpak and attach 1 EXCEL workbook
- Use Phstat to do the HW ( if you do not have the access code-do the above 2 methods) and attach one excel workbook
You are allowed to submit the assignment multiple times(4) until the due-date. Only the last submission will be graded.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached you will find the outline and the answers (a separate document per problem) of your homework. Please let me know if you need explanation about the answer or edits 😊
DATA
Provider
Verizon FIOS
WOW
Bright House Networks
A T & T U-verse
Cox
SuddenLink
Cablevision/Optimum
RCN
Comcast/Xfinity
TimeWarner
Charter
Mediacom
Wave/Astound
Cable One
TV Internet
73
74
74
76
68
70
68
68
64
68
65
70
63
67
65
71
59
62
58
63
59
64
54
58
72
74
63
68
D
-1
-2
-2
0
-4
-5
-4
-6
-3
-5
-5
-4
-2
-5
ANSWER
a. Evidence of significant difference between two related
H0
μD = 0
H1
μD ≠ 0
t-STAT
7.186
df
13
tCRIT, 0.05
2.160
There is enough evidence to reject H0, H1 is accepted
b. Assumptions of t-STAT (Distribution differences)
The differences are normally distributed
c. Graphical method for validity of normal distribution
Preliminary work
Mean
-3.429
Std Dev
1.785
n
14
The bloxplot is quite symmetrical, the values are skewed to
higher rating differences. There are no outliers. The mean
and the median are close to each other.
difference between two related means
d. 95% confidence interval of the difference between two independe...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Narrative of the Life of Frederick Douglass
by Frederick Douglass
Catch-22
by Joseph Heller
Fools Crow
by James Welch
Cry the Beloved Country
by Alan Paton
Principles - Life and Work
by Ray Dalio
Night
by Elie Wiesel
The Secret Garden
by Frances Hodgson Burnett
The Trial
by Franz Kafka
The Prince
by Niccolò Machiavelli