The following data was provided by the
Office of Statistics.
The data is based on the preliminary counts from the 2010 Federated States of Micronesia census.
The data examines the populations of municipalities in Pohnpei versus Kosrae and
the loss of overall population on Kosrae.
Implicit in this analysis are questions such as, "How much population should constitute a municipality?"
"Is there a point at which a municipality is too small to be considered a municipality."
Possibly the most sensitive implied question is,
"If the population of Kosrae is smaller than or on par with a single Pohnpeian municipal population,
should not Kosrae return to being a municipality?"
Part I: For questions one to four, use the Pohnpei data only.
Pohnpei
Pop
Sokehs
6640
Nett
6542
Kitti
6470
Kolonia
6068
Madolehnihmw
5662
U
3192
__________ Find the sample size n.
__________ Find the sample sum.
__________ Find the median.
__________ Find the sample mean x.
Part II: For questions five to eight, use the Kosrae data only.
Kosrae
Pop
Tafunsak
2173
Lelu
2160
Malem
1300
Utwe
982
__________ Find the sample size n.
__________ Find the sample sum.
__________ Find the median.
__________ Find the sample mean x.
__________ The sum is the population of each of the main islands.
Are there municipalities on Pohnpei with a larger population than the state of Kosrae?
Part III: For the following questions, use all the population data in the table below.
Pohnpei
Pop
Kosrae
Pop
Sokehs
6640
Tafunsak
2173
Nett
6542
Lelu
2160
Kitti
6470
Malem
1300
Kolonia
6068
Utwe
982
Madolehnihmw
5662
U
3192
_________ Determine the sample size n.
_________ Determine the minimum.
_________ Determine the maximum.
_________ Calculate the range.
_________ Determine the class width. Use six classes (bins or intervals).
Fill in the following table with the class upper limits in the first column,
the frequencies in the second column, and the relative frequencies in the third column
Classes (x)
Frequency f
Rel Freq p(x)
Sums:
Sketch a histogram of the relative frequency data.
__________________ What is the shape of the distribution?
Part IV: In the following section, use the Pohnpei municipal data.
Pohnpei
Pop
Sokehs
6640
Nett
6542
Kitti
6470
Kolonia
6068
Madolehnihmw
5662
U
3192
__________ Find the sample size n.
__________ Find the sample mean x.
__________ Find the sample standard deviation sx.
__________ Find the coefficient of variation CV.
_________ Calculate the standard error of the sample mean x
_________ Find tcritical for a confidence level c of 95%
_________ Determine the margin of error E for the sample mean x.
Write out the 95% confidence interval for the population mean μ
p(_____________ < μ < ___________) = 0.95
_________
Based on the confidence interval above, is the Kosrae municipality mean size of 1654
within the 95% confidence interval for the mean size of a Pohnpei municipality?
___________
Is the Kosraean mean municipality size too smallortoo large
compared to the mean size of a Pohnpeian municipality?
_________
Based on the confidence interval above, is the entire population of Kosrae of 6615
within the 95% confidence interval for the mean size of a Pohnpei municipality?
_________
Which is true, AorB?
A. The population size of a Kosrae state municipality is statistically equivalent to the population size of a Pohnpei state municipality.
OR
B. The population size of the entire population of Kosrae state is statistically equivalent to the population size of a Pohnpei state municipality.
Part V: Hypothesis Testing using the t-test
In part five you will run a two sample hypothesis test
on whether there is a statistically significant difference between two independent samples
using a risk of a type I error alpha α = 0.05
The sample data is the size of the municipalities in Pohnpei versus Kosrae state. The test will
determine whether the municipalities could come from a single population with a single mean.
In other words, based on the means, are the population sizes of the municipalities in the two states
equivalent or statistically significantly different?
Use a two-tailed t-test for two independent samples.
Pohnpei
Kosrae
Sokehs
6640
Tafunsak
2173
Nett
6542
Lelu
2160
Kitti
6470
Malem
1300
Kolonia
6068
Utwe
982
Madolehnihmw
5662
U
3192
_________ Calculate the sample mean x for a Pohnpei municipality.
_________ Calculate the sample mean x for a Kosrae municipality.
_________ Are the sample means for the two samples mathematically different?
__________________ What is the p-value? Use the TTEST function with two tails
to determine the p-value for this two sample data.
__________________ Is the difference in the means statistically significant
at a risk of a type I error alpha α = 0.05?
__________________ Would we fail to reject| or |reject
a null hypothesis of no difference in the sample means?
__________________ What is the maximum level of confidence we can have that the
difference in the means is statistically significant?
__________________
Based on the t-test, are the means statistically equivalent?
Part VI: Linear Regression
The table contains data on the population of Kosrae from 1980 to 2000. Use this data in this section.
Year
Population
1980
5500
1986
6607
1994
7317
2000
7686
_________ Calculate the slope of the linear regression (best fit line).
_________ Calculate the y-intercept of the linear regression (best fit line).
_________ Is the relation positive, negative, or neutral?
_________ Calculate the linear correlation coefficient r for the data.
______________ Is the correlation none, weak/low, moderate, strong/high, or perfect?
______________ Determine the coefficient of determination.
______________ What percent in the variation in year "explains" the variation in population?
_________ Use the slope and intercept to predict the population in the year 2010.
_________ Use the slope and intercept to determine the population in the year 2020.
Part VII: The table contains data on the population of Kosrae from 2000 to 2010. Use this data in this section.
Year
Population
2000
7686
2010
6616
_________ Calculate the slope of the linear regression (best fit line).
_________ Calculate the y-intercept of the linear regression (best fit line).
_________ Is the relation positive, negative, or neutral?
_________ Use the slope and intercept to predict the population in the year 2020.
_________ Is the year 2020 projection in #50 the same as the year 2020 projection in #46?
_________ The projected year 2020 population in Kosrae calculated in #50 would put the population of Kosrae below which Pohnpei municipality in rank order?
_________ Use the slope and intercept to predict the year in which the population of Kosrae state will be 0.