This task was to analyze the test scores of Eau Claire Memorial and Eau Claire North juniors. It appears that EC Memorial has the highest scores so therefore it seems that EC North students don't do as well. There has been an emphasis on this that maybe the EC North teachers are not as qualified or doing as good of a job. I have take the two sets of test scores and found different in my opinion and analysis of the data. To do this I found the range, mean, mode, median and standard deviation.
My analysis shows that EC Memorial does in fact have the highest score overall with 198 but it also has the lowest with 107. So with EC Memorial having such a high score and such a low score, it will make the mean average out. EC North's average was also higher with 160.92 and EC Memorial with 158.53. This shows that both schools had high scores and low scores.
Actually calculating the scores shows that if the one person with 198 had not gotten that score, then North would have been dramatically higher. It was the one outlier that caused the high mean.
I believe that showing the mean shows that each school is very similar overall.
Part 2: Using MS Excel and ArcGIS
In this task I will analyze the best area (s) for establishing organic goat farms. I computed the Mean, Median, Mode, Skewness, Kurtosis and Standard Deviation.
I computed the an\mount of organic farms and the amount of goat farms.
Organic Farms Goat Farms
Mean 16 Mean 34
Median 9.5 Median 31
Mode 5 Mode 35
Skewness 6.26 Skewness 0.86
Kurtosis 46.54 Kurtosis 0.53
Standard Deviation 28.19 Standard Deviation 23.20
First I found the number of goat farms to be overwhelming. Are there really that many goat farms?
Vernon County has 107 goat farms and they have 229 organic farms? Well that is sure not a place to put any more. There are a few counties that do not have any such as Menominee has no goat farms and no organic farms, Vilas has no organic and very few goat farms with 5. These numbers will pull the average way down. There are many other factors involved to decide where to put more farms such as soil, if it is in a flood plain or if there is enough market in that area to sustain another farm. Is there a reason that there are no farms in the areas that are available? There are counties that the average is set higher than it probably is. The skewness is much higher in the organic farms, maybe that is because the huge range of numbers. There are two farms with 0 and only one with 229 but there are several in the 30's, 40's and 50's. The standard deviation (28.2, organic and 23.2 for goat farms ) is higher in the organic farms as well. I believe this is also due to the extreme numbers from very high amounts to very low amounts of organic farms. In the goat farms, there are a few higher numbers such as 107 and 74 but these don't bring the average up as much as in the organic farms.
This map shows the Difference between the mean and actual farms which shows that mainly the northern part of the state has less farms and more room to add them if chosen to due so. Again depending on other factors.
|
Organic Farms per county shows the same information in regards to areas that could be developed. The northern part of the state and the south west corner have fewer farms. The dark colored county would have to be Vernon County according to the given data.
This map shows the total percent of organic farms as opposed to the previous map which shows per county. The same information is acquired as the northern and southwest parts of the state have little compared to the mid-eastern part of the state.
This map shows the percentage of goat farms per county and it shows close to the same data as the organic farms. The northern part of the state especially has less than the middle of the state and a few areas of the southeastern part of the state.
This map shows the Standard Deviation of goat farms, in every map it shows one county to have a higher number and on this map is shows that Vernon County has greater than 2.5 stdv about the rest of the state. The northern part of the state is still lower.
The fact that in every map the same places lack goat or organic farms, there would have to be further analysis on why there are no existing farms in these areas. It may be due to cold winters and the quality of soil or crop land. This area may be too populated. I know this isn't the case but if someone did not know that, it would be a good thing to investigate. There are many different factors to consider besides just the fact that there is room there. I do not feel these maps alone could help in the quest for locations for organic or goat farms.
