“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

A researcher is interested in the effects of family size on delinquency for a group of offenders and examines families with one to four children. She obtains a sample of 16 families, four of each size, and identifies the number of arrests per child for delinquency. The data are as follows:

Solved by X. Y. in 12 mins

The sheet names Baseball players, contains salary data on all major league baseball players for year 2015. Generate a simple random sample of size 30 from this population. Calculate the population mean of annual salary. Then calculate the sample mean of annual salary. What is the sampling error.

Solved by O. B. in 21 mins

1. The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. For this problem, consider this data set as the population frame. a. Generate a simple random sample of size 20 from this population. b. Generate a simple random sample of size 10 from this population. c. Calculate the population mean of Annual Salary. Then calculate the sample mean of Annual Salary for each of the samples in parts a and b. d. What is the sampling error for each of the samples in parts a and b. e. Comment briefly on how they compare to each other and the population measures.

Solved by A. A. in 27 mins

Use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [10%]. Compare these outcome figures. How do the mean and SD change with sample size? [10%].

Solved by G. Q. in 15 mins

Im trying to find formulas that calculate the values for slope, intercept, and r^2 for a log regression (the values from the log regression formula in the chart view).

Solved by O. J. in 29 mins