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 t_{critical} 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.