Free Essay

Anova

In:

Submitted By oalex2000
Words 289
Pages 2
ANOVA Excel Worksheet
The following table contains a random sample of 40 women partitioned into three groups:
Group 1: ages below 20
Group 2: ages 20 through 40
Group 3: ages over 40 the values in the table are systolic blood pressure levels
The Hypothesis test:
H0: μ1=μ2=μ3
H1: at least one of the treatment means is different use the Excel Analysis Toolpak to create an Anova- Single factor table. is there sufficient evidence to support the claim that women in different age categories have different mean blood pressure levels? Give for your decision.

Group 1 Group 2 Group 3 [Place your Anova table here] 104 97 123 106 116 107 Anova: Single Factor 104 98 127 92 95 133 SUMMARY 112 108 114 Groups Count Sum Average Variance 107 106 93 Group 1 102 113 Group 2 108 114 Group 3 94 116 100 155 101 105 ANOVA 119 Source of Variation SS df MS F P-value F-crit 89 Between Groups 113 Within Groups 99 93 Total 107 125 104 110 124 181 118
1 ANSWERS 0
SUMMARY
Groups Count Sum Average Variance group 1 6 625 104.1666667 44.17 group 2 23 2507 109 344.91 group 3 11 1300 118.1818182 267.56

ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 937.93 2 468.97 1.655 0.205 3.252
Within Groups 10484.47 37 283.36

Total 11422.4 39

And the P-Value of .205 is greater .05 so I believe we can say with 95% confidence that the populations are different. But I'm not a stats guy so take that with a grain of salt.
-------------------------------------------------
Top of Form
0 0

Similar Documents

Free Essay

One Way Anova Using Spss

...One Way ANOVA using SPSS Introduction The one-way analysis of variance (ANOVA) is used to determine whether there are any significant differences between the means of two or more independent (unrelated) groups (although you tend to only see it used when there are a minimum of three, rather than two groups). For example, you could use a one-way ANOVA to understand whether exam performance differed based on test anxiety levels amongst students, dividing students into three independent groups (e.g., low, medium and high-stressed students). It is important to realise that the one-way ANOVA is an omnibus test statistic and cannot tell you which specific groups were significantly different from each other; it only tells you that at least two groups were different. Since you may have three, four, five or more groups in your study design, determining which of these groups differ from each other is important. You can do this using a post-hoc test (N.B., we discuss post-hoc tests later in this guide) Example A manager wants to raise the productivity at his company by increasing the speed at which his employees can use a particular spreadsheet program. As he does not have the skills in-house, he employs an external agency which provides training in this spreadsheet program. They offer 3 courses: a beginner, intermediate and advanced course. He is unsure which course is needed for the type of work they do at his company, so he sends 10 employees on the beginner course, 10 on the intermediate...

Words: 634 - Pages: 3

Premium Essay

Anova

...1. You are the manager of the Gander Mountain store in Frogtown, Illinois. Recently, a customer mentioned that they believed your prices for ammunition were lower than the prices of Gander Mountain's primary competitor in the hunting equipment store, Cabela's. You would like to be able to include that statement in a forthcoming print advertisement, so you need statistical evidence to support this assertion. (A) Identify the null and alternative hypotheses needed to test the contention. H0: Gander Mountain ammunition prices <= Cabela’s ammunition prices HA: Gander Mountain ammunition prices > Cabela’s ammunition prices (B) Then identify the most appropriate sample selection technique to gather data for testing the hypotheses. In order to gather the sample I would use a probability sample or simple random sample selection to gather data to test the hypothesis. (C) What statistical test should you use to accept or reject this hypothesis using the data you will collect? The test that I would use to accept or reject the null hypothesis is the t-test: two sample assuming equal variances since we have two independent samples. 2. Your love of golf has brought you back to the range as the new product manager for UniDun's Straight Flight (SF) line of golf balls. The company's research and development group has been experimenting with dimple patterns that promote straight flight and feel they have achieved some degree of success. You, however, are worried about the effect...

Words: 1355 - Pages: 6

Premium Essay

Anova

...Mean |   | 3.16 | Attractive | Acceptable | Table1.1 shows the ratings of the respondents on the different treatments of potato fries on sensory evaluation in terms of color. Treatment 2 got the highest mean of 3.53 followed by Treatment 3 with a mean of 3.20. Treatment 4 obtained a mean of 3.00 treatment 1 got the lowest mean of 2.90.  The result implies that the color of the treatment of potato fries are “attractive” and interpreted as “acceptable” as reflected by the section mean of 3.16. Table 1.2 Analysis of variance (ANOVA) on the different treatments of Potato fries in terms of Color.   Sources of Variance | Sum of Squares | DF | Means of Squares | F- computed | F- tab0.05       0.01 | Treatments | 14.05 | 3 | 4.68 | 6.88 | 3.13 4.58 | Error | 159.93 | 236 | 0.68 | | | Total | 173.98 | 239 | | | | * *Significant Difference ( At 0.05 and 0.01 level of significance) |   Table 1.2 shows the analysis of variance (ANOVA) on the different treatments of potato fries in terms of color. Statistical analysis shows the f- computed of 6.88. The tabular value of f  is 3.13 at 0.05 level of significance and 4.58...

Words: 2610 - Pages: 11

Premium Essay

Anova

...ANOVA Analysis of variance (ANOVA) is a collection of statistical models used to analyze the differences between group means and their associated procedures (such as "variation" among and between groups), developed by R.A. Fisher. In the ANOVA setting, the observed variance in a particular variable is partitioned into components attributable to different sources of variation. In its simplest form, ANOVA provides a statistical test of whether or not the means of several groups are equal, and therefore generalizes the t-test to more than two groups. As doing multiple two-sample t-tests would result in an increased chance of committing a statistical type I error, ANOVAs are useful in comparing (testing) three or more means (groups or variables) for statistical significance. The analysis of variance can be used as an exploratory tool to explain observations. A dog show provides an example. A dog show is not a random sampling of the breed: it is typically limited to dogs that are male, adult, pure-bred, and exemplary. A histogram of dog weights from a show might plausibly be rather complex, like the yellow-orange distribution shown in the illustrations. Suppose we wanted to predict the weight of a dog based on a certain set of characteristics of each dog. Before we could do that, we would need to explain the distribution of weights by dividing the dog population into groups based on those characteristics. A successful grouping will split dogs such that a) each group has a low variance...

Words: 660 - Pages: 3

Premium Essay

Anova

...Team E has decided to use an ANOVA to see if there is a difference in the mean net income from the telecommunications sector, the financial sector, and the energy sector, we will be using the .05 significance level. The research question is “Does the financial sector, the telecommunication sector and the energy sector all share the same average net income.” ANOVA or analysis of variance allows team E to compare more than two means simultaneously. In formulating the hypothesis statement using ANOVA, the team has decided on a null hypothesis that mean net income from the three different financial sectors are equal. After developing the null and alternate hypothesis, Team E preformed the five steps of hypothesis testing using MegaStat and Microsoft Excel (Doane & Seward, 2007). Step 1: State the Hypotheses The hypotheses to be tested are Ho: μt =μf =μe H1: Not all the means are equal (at least one mean is different). Step 2: State the Decision Rule There is c = 3 groups and n = 75 observations, so degrees of freedom for the F test are: Numerator: d.f. 1 = c -1 = 3 -1 =2 (between treatments, factor) Denominator: d.f.2 = n –c = 75 -3 =71 (within treatments, error) Step 3: Select a Level of Significance We will use a = .05 for the test. The 5 percent right-tail critical value from Appendix F is F(3,25) = 3.13 Step 4: Perform the Calculations/ Test Statistics Using MegaStat for the calculations, we obtained the results shown in the Excel Spread sheet. Excels default...

Words: 464 - Pages: 2

Premium Essay

Anova

...ANOVA Simulation Working as a quality control manager is no easy task. There are a lot of variables that are involved in it. Knowing how to research specific problems truned out to be crucial when it came to solve a specific problem, which opened my eyes as to the complication involved in it. There are two specific test used in this particular simulation which are Anova and Non-parametric. “Anova is defined as a statistical method for making simultaneous comparisons between two or more means; a statistical method that yields values that can be tested to determine whether a significant relation exists between variables.” (dictionary.com) “A non parametric test is a branch of statistics that are applied when populations are not normal or they are severely skewed data.” There were three lessons learned during this simulation which were how to monitor a situation. The importance to measuring the accumulated data and how to provide a reliable solution to the problem. It is important that we learn how to apply things that we learn in everyday life as well as the workplace. Using an appropriate test can help us whenever it is time to make a decision in business, which is one other thing learn while going over the simulation. This helps at the time of determining how to correct a stiuation in the workplace. Training in customer service and technical support has shown to be crucial in the company shown in the simulation this information is shown during the...

Words: 423 - Pages: 2

Premium Essay

Anova

...Applying ANOVA and Nonparametric Tests Simulation Many organizations use various tools to ensure quality assurance and management for their business. The challenge for them is to ensure that they provide the best quality of service to their clients in a time effective manner. As such, having a diversity of tool options in place helps the organization identify daily challenges and increase overall effectiveness practices in their decision making processes. Implicitly, identifying the problems is the first key component towards making a sound decision. Once the problems are identified organizations can use tests such as ANOVA, nonparametric test and Kruskal-Wallis test for operational research methods and total quality management. These methods will allow researchers to analyze significant data that will subsequently result in implementation of the found solutions. Accordingly, the Praxidike Systems Corporation has identified a problem with their turn-around time in delivering products to their clients. With that, using the ANOVA, nonparametric and Kruskal- Wallis test has taught me that utilizing these tools can assist in analyzing information in order to make the best possible decision for the organization. Furthermore, using these tools help make the process easier to control by breaking down the data into various groups in order to manage the information. When using these tools, it is easy to apply what was reviewed to everyday life especially...

Words: 354 - Pages: 2

Premium Essay

Anova

...a John S. Harris BIS/219 Mr. Koshy Joseph-Vaidyan Software Applications Software Applications Organizational employees in today's association are carrying out numerous processes in an association by advance made in technology. Programs applications and proposal systems improve regularly, accuracy reliability of tasks that enable employees to perform complex task with ease, and timeliness. Each department in an organization benefits from applications and information resources. One application that enables the finance department to perform task skillfully is the Accounting Information Systems. AIS cover business functions from traditional accounting transaction processing systems to complex financial management planning and processing systems. By touching a button the user can obtain the information one needs to manage and control an organization. If one works in the marketing department one would benefit from Customer relationship management. CRM is used the most in large organizations. In an article presented by Richard Whitney a head vice president director, Marketing Database Services, CRM emerged in the late 90s as a mechanical strategy to improve the process companies enhance client’s service and bond. This software breaks the way organizations operate by automating and integrating marketing, sales and service The marketing and sales department can capture, store, and organize information with the use of CRM to better improve the quality of service to existing...

Words: 505 - Pages: 3

Premium Essay

Anova Lecture

...Topic: ANOVA Our topic is about the Analysis of Variance(ANOVA). This is use to compare means of 3 or more populations. You may encounter the word treatment. Treatment is a cause or specific source of variation in a set of data. Here are the assumptions: 1. the three or more population of interest are normally distributed. 2. These pop have equal standard deviation [pic]. 3. The sample we select from each of the population are random and independent. Test: F ratio of two variance F = Estimated pop variance based on variation bet the sample means Estimated pop variance bases on variation within samples ANOVA SV SS DF MS Treatment 1/2 (between columns) SST k-1 SST/k-1 Error (Between row) SSE N-k SSE/N-k Total SS F = SST/k-1 SSE/N-k SSTreat = [pic] SSTotal= [pic] SSError= SSTotal-SSTreat. Below is the example (You may also read the powerpoint on ANOVA for more examples. Example: Susan predicts that students will learn most effectively with a constant background sound, as opposed to an unpredictable sound or no sound at all. She randomly divides twenty-four students into three groups of eight. All students study a passage of text for 30 minutes. Those in group 1 study with background sound at a constant volume in the background. Those in group 2 study with noise that changes volume periodically. Those in group 3 study with no sound at...

Words: 585 - Pages: 3

Free Essay

Anova Analysis

...|Applying Analysis of Variance | |[Anova test simulation] | |Rochelle Kuebler | |[September 23, 2011] |      Praxidike is a software company, which has concern defining why their assignments are not done on time. The set-up starts by handing out two nonparametric analysis methods that include ANOVA and Kruskal-Wallis. Nonparametric testing procedures need definite requests to make use of efficiently. The key norms of ANOVA testing consist of the following: the population consumes a standard distribution, mistakes are independent, and population consumes the same variance. The Kruskal-Wallis test, instead, does not involve the hypothesis of a common distribution and the facts need to be on an ordinal measure. This is characteristically a superior choice if the expectations of ANOVA will not be met. This setup runs three examples of how certain testing systems can be practical to real-world circumstances. The first part of the situation is to relate the Kruskal-Wallis test because the expectations of ANOVA may not be seen. After studying the facts, it was obvious that the level of capability dealing with the software...

Words: 511 - Pages: 3

Premium Essay

Anova Paper

...Variance and Nonparametric Tests Paper Andy Martinez Res/342 February 1, 2012 Victor Ornelas Most recent concepts are ANOVA and nonparametric tests. ANOVA, also known as analysis of variance is a concept that allows you to “compare more than two means simultaneously and how to trace sources of variation to potential explanatory factors”. One of the biggest take away from this concept is that the ANOVA tests can take on many factors or “treatments. This can be very beneficial when dealing with many factors. Although this does not mean that it is the norm to have many factors. Most researchers focus on a limited amount of factors. Another big lesson is with nonparametric tests. Working for a company that requires that we learn how comfortable our users are with their technology it is very important to use ordinal data for informative decision making. In our data sets there is a large majority of information that does not come in with a normal distribution. This is where it comes into play that a parametric test can aid due to the ability to examine information without normal distribution. One of the largest lessons in terms of these concepts is the data size that it takes to utilize these tests. Unfortunately as with any questionnaire my department usually gets only a small amount back. When working with parametric testing a small sample size would only go to hurt the result of the testing. When working with these tests it is possible to extrapolate the data...

Words: 334 - Pages: 2

Free Essay

Anova Exercise

...Contoh 1: Peneliti bidang kehutanan ingin mengetahui pengaruh penggunaan hormon X pemacu pertumbuhan pohon mahoni. Larutan hormon X disuntikkan ke batang mahoni setiap 3 hari sekali, dosis yang digunakan adalah 10 gram/lt, 20 gr/lt, 30 gr/lt dan 40 gr/lt. Setelah dua tahun diameter mahoni tersebut diamati. Dosis manakah yang paling baik? Data-data hasil penelitian diperoleh sebagai berikut: Dosis Penyuntikan 10 gr/L | 20 gr/L | 30 gr/L | 40 gr/L | 43 | 61 | 100 | 70 | 28 | 66 | 109 | 72 | 26 | 44 | 98 | 73 | 39 | 57 | 102 | 68 | 39 | 61 | 98 | 89 | 46 | 72 | 88 | 75 | 38 | 68 | 89 | 62 | 20 | 64 | 106 | 63 | 57 | 67 | 102 | 66 | 23 | 74 | 105 | 69 | Contoh 2: Empat formulasi produk baru akan diujikan kepada konsumen sebelum launching ke pasar. Hasil penilaian tingkat kesukaan dari keempat produk tersebut oleh 30 konsumen adalah seperti di bawah ini. Tentukan formulasi mana yang sebaiknya dipilih untuk launching. Panelis | A | B | C | D | 1 | 1 | 4 | 5 | 4 | 2 | 4 | 6 | 6 | 6 | 3 | 1 | 4 | 6 | 7 | 4 | 4 | 8 | 7 | 1 | 5 | 2 | 4 | 3 | 4 | 6 | 1 | 4 | 5 | 5 | 7 | 3 | 3 | 6 | 3 | 8 | 0 | 2 | 4 | 5 | 9 | 6 | 2 | 9 | 5 | 10 | 7 | 8 | 9 | 1 | 11 | 0 | 7 | 2 | 4 | 12 | 1 | 1 | 6 | 4 | 13 | 4 | 5 | 7 | 4 | 14 | 1 | 5 | 5 | 6 | 15 | 4 | 6 | 6 | 5 | 16 | 2 | 7 | 5 | 2 | 17 | 2 | 2 | 7 | 3 | 18 | 4 | 6 | 7 | 6 | 19 | 0 | 5 | 4 | 3 | 20 | 5 | 3 | 5 | 4 | 21 | 2 | 4 | 3 | 6 | 22 | 3 | 3 | 7 | 0 | 23 | 3 | 6 |...

Words: 310 - Pages: 2

Premium Essay

Anova Midterm Review

...variable Experimental and observational design Factor/factor level Treatment/Treatment combination Experimental unit Balanced design Randomization Control group Source of variations Linear model Indicator variable ANOVA table decomposition Interpreting SAS output with respect to 1-way and 2-way ANOVA model Interpret data plots to identify visual differences between groups Understand the cell means model and the factor effects model: parameters and estimates Compute parameter estimates for cell means/factor effects model given a table of means Conduct the F-test for testing the equality of factor level means Compute CI’s for differences between means Multiple comparison methods: LSD, Tukey, Bonferroni, and Scheffe Diagnostics of model assumptions and remedial measures: three key assumptions on the error terms of ANOVA/ transformation methods Residual analysis Regression model corresponding to ANOVA model Review problems: These are the minimum knowledge to get ready for the exam. You should study thoroughly text book material and lecture notes to be well prepared for the exam. 1. Indicate how you would check that the three key assumptions on the error terms for ANOVA model are satisfied. 2. Conducting the one-way ANOVA for the following data, write the cell means and factor effects model and the corresponding parameter estimates....

Words: 526 - Pages: 3

Premium Essay

T-Test and Anova

...BUS 310 Notes regarding Two-Sample t-Tests and ANOVAs In Chapter 9, we learned how to conduct a t test of a hypothesis when we were testing the mean of a single sample group against some pre-determined value (i.e., the 21.6 gallons of milk consumption as the national average). This week, in Chapter 10, we will see how to test hypotheses that involve more than one sample group—such as testing to see if males are significantly taller than females. If we have two groups, then the technique that we will use will still be a t test. If we have more than two groups, then we will have to use a different test called Analysis of Variance (ANOVA, for short). The good news is that the decision rules for hypothesis testing that we learned last week are still exactly the same: Set #1: If the absolute value (ignore any negative sign) of the test statistic is greater than or equal to the critical value, then you reject the null. If the absolute value of the test statistic is less than the critical value, you do not reject the null. Set #2: If the p value is less than or equal to α, reject the null. If the p value is greater than α, do not reject the null. (Remember that we must either reject or not reject the null—we never accept the null.) In order to conduct these tests, we will need to use the data analysis feature of Excel, which probably is not installed for you, but that’s OK, because it’s available and pretty simple to install—just follow these steps: ...

Words: 2114 - Pages: 9

Free Essay

Anova and Nonparametric Tests

...ANOVA and Parametric tests Looking at the concepts in the book it is interesting with regard to placing them into the work world. The most recent concepts were ANOVA and nonparametric tests. ANOVA, also known as analysis of variance is a concept that allows you to “compare more than two means simultaneously and how to trace sources of variation to potential explanatory factors”. One of the biggest take aways from this concept is that the ANOVA tests can take on many factors or “treatments. This can be very beneficial when dealing with many factors. Although this does not mean that it is the norm to have many factors. Most researchers focus on a limited amount of factors. Another big lesson is with nonparametric tests. Working for a company that requires that we learn how comfortable our users are with their technology it is very important to use ordinal data for informative decision making. In our data sets there is a large majority of information that does not come in with a normal distribution. This is where it comes into play that a parametric test can aid due to the ability to examine information without normal distribution. One of the largest lessons in terms of these concepts is the data size that it takes to utilize these tests. Unfortunately as with any questionnaire my department usually gets only a small amount back. When working with parametric testing a small sample size would only go to hurt the result of the testing. When working with these tests it is possible...

Words: 344 - Pages: 2