Question

how do i solve these in excel?

The following table shows the total points scored in 16 football games played during week 1 of the season in a youth football league. Use the data to complete parts a through e below. 23 29 33 54 65 49 25 35 45 58 37 44 36 27 18 32 a. Calculate the mean for this population. H- 38.1 H- 38.1 (Round to one decimal place as needed.) b. Calculate the sampling error using the first four games in the first row as your sample. The sampling error for the first four games is -3.4 Round to one decimal place as needed.) c. Calculate the sampling error using all eight games in the first row as your sample. The sampling error for the first eight games is 1.0. Round to one decimal place as needed.) d. How does increasing the sample size affect the sampling error? OA. In general, increasing the sample size makes the sampling error larger. 0 B. In general, increasing the sample size has no effect on the sampling error. C. In general, increasing the sample size makes the sampling error smaller. e. Using a sample of size four, what is the largest sampling error that can be observed from this population? The largest sampling error for the given data using a sample of size four is 18.4 Round to one decimal place as needed.) Determine the sample size n needed to construct a 99% confidence interval to estimate the population mean for the following margins of error when σ-75. a) 15 b) 25 c) 30 Click the icon to view a table of standard normal cumulative probabilities a) n- 166 (Round up to the nearest integer.) b) n- 60 (Round up to the nearest integer.) c) n42 (Round up to the nearest integer.) A university would like to estimate the proportion of fans who purchase concessions at the first basketball game of the season. The basketball facility has a capacity of 3,500 and is routinely sold out. It was discovered that a total of 200 fans out of a random sample of 500 purchased concessions during the game. Construct a 95% confidence interval to estimate the proportion of fans who purchased concessions during the game The 95% confidence interval to estimate the proportion of fans who purchased concessions during the game is 0.360 0.440 For a population with a mean equal to 150 and a standard deviation equal to 25, calculate the standard error of the mean for the following sample sizes. a) 10 b) 30 c) 50 a) The standard error of the mean for a sample size of 10 is 7.91. Round to two decimal places as needed.) 6 b) The standard error of the mean for a sample size of 30 is 4.56 Round to two decimal places as needed.) c) The standard error of the mean for a sample size of 50 is 3.54 Round to two decimal places as needed.)

Answer 1

Mean value is calculated by

$\mu = \frac{\sum X}{n}$

Where X = given data values

n = number of data

Here mean

$\mu$ = ( 23+29+33+54+65+49+25+35+45+58+37+44+36+27+18+32)/16

= 610/16

= 38.125

= 38.1

b) sampling error for first 4 games mean of first four games is

  $\mu$_sample = (23+29+33+54)/4

= 139/4

= 34.75

= 34.7

Sampling error = $\mu$_sample  - $\mu$

_. = 34.7- 38.1

= - 3.4

c) considering first 8 games in the first row

  $\mu$_sample = (23+29+33+54+65+49+25+35)/8

= 39.125

= 39.1

Sampling error = 39.1- 38.1

= 1.0

d) we know that in general increasing the sample size makes the sampling error smaller .Hence answer is C

e) largest sampling error that a 4 group sample can produce is with largest sample mean .In order to get largest sample mean use large sample values hence taking 4 large sample

65 , 58 , 54 , 49

$\mu$_sample = (65+58+54+49)/4

= 226/4

= 56.5

Largest sampling error = 56.5- 38.1

= 18.4

We know margin error can be calculated as

ME = $t^{*}\frac{\sigma}{\sqrt{n}}$

t^* = 2.576 because given 99% interval

n = sample size

$\sigma$ = standard deviation

= 75

a). ME = 15

$\sqrt{n}$ = t* 75/15

= 2.576×75 /15

= 12.88

n = 12.88²

=165.89

= 166

b). ME = 25

$\sqrt{n}$ = 2.576× 75/25

= 7.728

n = 7.728²

= 59.7

= 60

c) . ME = 30

  $\sqrt{n}$ = 2.576× 75 /30

= 6.44

n = 6.44²

= 41.5

= 42