Jar Jar Binks.xls by censhunay

VIEWS: 2 PAGES: 8

• pg 1
```									       On a scale of one to ten, how much did the addition of Jar Jar Binks to the
Star Wars series affect a fan's devotion?
Heather Yost

Devotion Scale of 1-10 for Star Wars
After
Before Jar Jar Jar Jar
Fan 1            5         5
Fan 2             9         6
Fan 3            10         7
Fan 4             1         1
Fan 5             8         6
Fan 6            10         9
The Preperation for the Hypothesis Test:          Fan 7            10        10
Since I believe that I am the only person in      Fan 8             9         2
the world that likes the addition of Jar Jar      Fan 9            10         1
Binks to Star Wars, I decided to check out        Fan 10            5         9
that hypothesis. In other words, does his         Fan 11            3         5
addition to the series really lower the high      Fan 12            8         1
standing most devote fans have for this           Fan 13            9         3
series? I believe that it actually did since I    Fan 14            9         8
haven't met too many supporters of the cute       Fan 15            6         1
creature. Therefore, in order to obtain this      Fan 16            5         5
information, I asked twenty-five college          Fan 17            8         4
students what they would rank their               Fan 18           10         5
devotion to Star Wars as, given the older         Fan 19           10        10
trilogies, on a scale of 1 to 10. Then, I asked   Fan 20            8         4
them what they would rank their devotion as       Fan 21            9         4
after I mention the addition of Jar Jar Binks     Fan 22            8         7
in the first one of the new trilogies. Thus, I    Fan 23            8         8
have paired results, which limits bias results    Fan 24            6         4
and also is prime material to use the t-test      Fan 25           10         9
hypothesis since it is relatively small and I
want a 5 % level for differences in means.         Mean           7.76     5.36
The smallness of the 5 % is to enable one to      St. Dev.        2.42     2.91
visualize the absurdity, if there is one, of       Count            25       25
fans lowering their devotion to Star Wars.
The two samples are distributed Normally,
and the t-test enables me to test for the
difference in the means by giving me a
critical t and a t-stat. Although the
observations are samples from a larger
population, the amount of samples used, 25,
is a decent contribution to understanding
how the population works as a whole.

I have taken the Mean of the samples, and
it shrinks with the after Jar Jar sample and
the Standard Deviation grows slightly. But I                         Next Sheet
am not able to determine the true outcome
am not able to determine the true outcome
from those results alone.
Jar Binks to the

of 1-10 for Star Wars
Matched Difference
0
-3
-3
0
-2
-1
0
-7
-9
4
2
-7
-6
-1
-5
0
-4
-5
0
-4
-5
-1
0
-2
-1

-2.4
3.08
25
Process: I used, from the Tools Menu, the Data Anyalsis
Function to generate results for the t test hypothesis, used
because I have a relatively small sample size and paired
results. The process compares paired sample means. It is
called Test: Paired Two Sample for Means on the Menu Bar.
The Hypothesized Mean Difference is 0 simply to enable me
to test my hypothesis that their is a difference. Therefore if
their is a difference, my t Stat will be greater than my critical t,
and I will be able to reject the null hypothesis that their isn't a
difference and accept mine that there is one. Thus, this
function will give me all the results that I need inabling me to
test my theory.

t-Test: Paired Two Sample for Means
Variable 1 Variable 2
The Results: The T-Stat is 3.8933, and I
Mean           7.76       5.36
must use the t critical one
Variance      5.856667        8.49
determine if the fans' devotion depreciated
Observations               25         25
(If I just wanted to know that a difference
Pearson Correlation       0.343664
had taken place I would use the two
Hypothesized Mean Difference                0
df           24
test.) The t critical one-
t Stat    3.893314
my T-Stat is much higher than my T critica
P(T<=t) one-tail      0.000345               one-tail. Hence, the devotion of fans has
t Critical one-tail    1.710882               gone down with the Addition of Jar Jar
P(T<=t) two-tail       0.00069               Binks to the Star Wars series. The null
t Critical two-tail    2.063898               hypothesis must be rejected since there is
a difference in the devotion of fans toward
Star Wars.
Degrees of Freedom: 24
T Stat: 3.98
Critical T (one-tailed): 1.71

Next Sheet
The T-Stat is 3.8933, and I
the t critical one-tail test to
e if the fans' devotion depreciated.
anted to know that a difference
place I would use the two-tailed
t critical one-tail is 1.712. Thus,
is much higher than my T critical
Hence, the devotion of fans has
n with the Addition of Jar Jar
he Star Wars series. The null
s must be rejected since there is
ce in the devotion of fans toward
Mesa
don'ta
thinka
People like
me..

Before                                     after
Bin               Frequency mid bin    rel. freq.               Bin          Frequency mid bin    rel. Freq.
1           1        0.5       0.042                       1           4        0.5       0.148
2           0        1.5       0.000                       2           1        1.5       0.037
3           1        2.5       0.042                       3           2        2.5       0.074
4           0        3.5       0.000                       4           4        3.5       0.148
5           3        4.5       0.125                       5           4        4.5       0.148
6           2        5.5       0.083                       6           3        5.5       0.111
7           0        6.5       0.000                       7           2        6.5       0.074
8           6        7.5       0.250                       8           2        7.5       0.074
9           5        8.5       0.208                       9           3        8.5       0.111
10           7        9.5       0.292                      10           2        9.5       0.074

sum                         25                                 sum                    27

To further illustrate the point made,
Relative Frequency Of Devotion
I did a relative Frequency chart to
show the fans that had really high
0.350                                             Before Jar                devotion before Jar Jar Binks
0.300                                             Jar                       dropped significantly, going from a
Rel. Freq.

0.250                                                                       .3 in relative frequency to a little
0.200                                                                       less than .1.
After Jar Jar
0.150
0.100
0.050
0.000
0              5               10
Mid Bin