; Jar Jar Binks.xls
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Jar Jar Binks.xls

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
e the point made,
 quency chart to
t had really high
ar Jar Binks
ntly, going from a
 ency to a little

								
To top