Stats Help for College-level Students

Excel scatter diagram

Given the following data, 1) how do you make Excel create a scatter diagram for you? 2) If you were to draw a line through the points, how straight would the line be? 3) What is the coefficient of determination - r2 for this data, and more importantly, 4) what does it mean? # Employees # Orders received 1 1 ...continues

Scatter diagram

Given the following data, create a scatter diagram (using Excel), click on the points as demonstrated in the Excel workbook, and have Excel place the regression equation and coefficient of correlation on the graph for you. Interpret the results (in English). Years of Education Annual Income (000's) 6 ...continues

Sources of Variation

Average time it takes to process applications Office 1 Office 2 Office 3 Employee 1 15 11 17 Employee 2 17 21 15 Employee 3 14 12 17 Employee 4 16 27 16 Excel Output - Anova: Single Factor SUMMARY Groups Count Sum Average Variance Column 1 4 62 15.5 1.666667 Column 2 4 71 17.75 58.2 ...continues

Regression

1) Referencing regression, how do you determine what is the independent and dependent variable? 2) How do you tell the difference between the x and y-axis? Given the following data, # Employees # Orders received 1 12 2 10 4 9 3 11 5 12 4 ...continues

Regression

1) Given the following data and Excel output, what is the English meaning of the numbers? Years of Education Annual Income (000's) 6 10 7 13 8 15 7 14 9 16 12 21 11 22 14 20 16 19 20 45 13 35 15 36 Regression Statistics Multiple R 0.837129 R Square 0.700785 Adjusted R Square 0 ...continues

Hypothesis, population variance...

Easy Eye, Inc. manufacturers adult sunglasses of all types. The company's management is not sure whether to target the next promotional campaign primarily toward men or women and has asked the research team to determine whether the market for sunglasses is split in half. A study is conducted at various cooperating stores selli ...continues

Population variance

The population variance is hypothesized to be 35.5 and a sample of 26 observations yields a standard deviation of 7. What is the value of the chi-square test statistic? Which one? a. 4.93 b. 18.1 c. 34.5 d. 35.9

Chi-squared

A chi-square test statistic was calculated to be 18, based on a sample variance of 20 and a hypothesized population variance of 40. How many observations were made when the sample was extracted? Which one? a. 9 b. 10 c. 36 d. 37

Compare population means

What must be checked in order to compare two population means when you do not know the values of the population standard deviation? Which one? a. the range b. the standard deviation for each sample c. the distribution of the test statistic d. the size of the sample

two populations

The email usage for two different plants of a large company was compared at level of significance 0.05. A sample of 50 employees was selected at each plant. The mean number of email messages sent per employee for one plant was 15.5 per week and the standard deviation was 5.0. For the other plant, the mean was 18.4 and the stan ...continues