Phil wants to compare two means.
His sample statistics were 
1 = 22.7,
s12 = 5.4, n1 = 9 and 2 = 20.5,
s22 = 3.6, n2 = 9.
Assuming equal variances, the test statistic is
Please provide solution calculations and excel solution
Homework Answers
### By using Excel
Spreadsheet:
Add Answer to:
Phil wants to compare two means.
His sample statistics were 1 = 22.7,
s12 = 5.4,...
John has obtained two independent samples form two populations, where the sample statistics are shown in...
John has obtained two independent samples form two populations, where the sample statistics are shown in the table below. Assuming equal variances, he can construct a 95% confidence interval for the difference of the population means to be Sample 1 Sample 2 Mean 22.7 20.5 Variances (s^2) 5.4 3.6 Observations (sample size) 9 9 [0.08, 4.32] [1.17,5.08] [2.44,6.19] [-0.09,3.19] True or False? A new policy of “flex hours” is proposed. Random Sampling showed that 40 of 50 female workers favored...
John has obtained two independent samples from two populations, where the sample statistics are shown in...
John has obtained two independent samples from two populations, where the sample statistics are shown in the table below. Assuming equal variances, he can construct a 95 percent confidence interval for the difference of the population means to be Sample 1 Sample 2 Mean 22.7 20.5 Variance (s^2) 5.4 3.6 Observations (sample size) 9 9 [0.08, 4.32] [1.17, 5.08] [2.44,6.19] [-0.09, 3.19] A corporate analyst is testing whether mean inventory turnover has increased. Inventory turnover in six randomly chosen product...
For the following two datasets labeled y1 and y2 match one quantity in column A with...
For the following two datasets labeled y1 and y2 match one quantity in column A with one quantity in column B. The sample means and variances are labeled as y1, y2, S12 and S22. The population means and variances from which they were drawn are labeled μ1,μ2, σ12, and σ22. Assume that the two samples are independent random samples. H0: μ1=μ2 against the alternative Ha: μ1≠μ2 using significance level α=.01. Using the data from problem 1 provide the following information...
CASE 1(continued) The manager of Roth Corporation, wants to determine whether or not the type of...
CASE 1(continued) The manager of Roth Corporation, wants to determine whether or not the type of wark schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 emplayees to each of the 3 proposed work schedules. The fallowing table shows the units of praduction (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 Schedule 2 Schedule 3 60 65 65 58 57 50...
6. A bank with a branch located in Crown Point wants to develop an improved process...
6. A bank with a branch located in Crown Point wants to develop an improved process for serving customers during the noon-to-lpm lunch period. Management decides to first study the waiting time of the current process. Data is collected from a random sample of 15 customer and their waiting time is recorded (in minutes) and is located in the Excel data file for this assignment under the tab CPBank. For comparative purposes, similar data is collected from a bank in...
Q2) Independent-Samples t-Test (15 points total) Help with H, I, J, K, L please! In a...
Q2) Independent-Samples t-Test (15 points total) Help with H, I, J, K, L please! In a research project, researchers collected demographic and health data from a sample of elderly residents in the community. To examine any possible gender differences in their sample, they want to see if the females and the males differ significantly on the education level (number of years of formal schooling). The researchers are not predicting any direction in the possible gender differences so the hypotheses should...
Create two excel graphs and descriptive statistics: 1 - Descriptive Statistics using data from attached file...
Create two excel graphs and descriptive statistics:
1 - Descriptive Statistics using data from attached file (Males)
and appropriate graph.
2 - Descriptive Statistics using data from attached file
(Females) and appropriate graph.
Create appropriate titles and grid lines Identify a variable to
be used as a basis for comparison between the two genders. Do not
use age or Blood Pressure. Create an appropriate graph. Are there
any outliers? Check for the outliers by creating the 5 number
summary doing...
1) Answer the question True or False. 1) Nonparametric methods focus on the location of the...
1) Answer the question True or False. 1) Nonparametric methods focus on the location of the probability distribution, rather than on specific parameters of the population. A) True B) False 2) Nonparametric tests are useful for qualitative data that can be ranked. A) True B) False 3) The sign test provides inferences about the population median rather than the population mean. A) True B) False 4) For a sign test to be valid, a large sample must be selected from...
Please do all questions... A cell phone battery manufacturer claims that one of their batteries for...
Please do all questions...
A cell phone battery manufacturer claims that one of their batteries for a particular cell phone will outperform a competitor's equivalent brand. To establish this claim, a researcher selected samples of the two brands of batteries and perform accelerated tests on them in the lab under identical conditions. A random sample of 55 of the manufacturer's battery was selected and placed on test. A corresponding random sample of 55 of the competitor's battery was also put...
Based on the Employment Situation Summary below, answer the following questions: 1. What month (and year)...
Based on the Employment Situation Summary
below, answer the following questions:
1. What month (and year) is summarized?
What was the unemployment rate for that month?
How does that rate compare with the rate in the previous month?
2. What were the unemployment rates for adult women, teenagers,
blacks, hispanics, and whites?
How did these rates compare with those a month earlier?
3. What factors make it difficult to determine the unemployment
rate?
4. Why is unemployment an economic problem?...
CASE 1(continued) The manager of Roth Corporation, wants to determine whether or not the type of wark schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 emplayees to each of the 3 proposed work schedules. The fallowing table shows the units of praduction (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 Schedule 2 Schedule 3 60 65 65 58 57 50...
6. A bank with a branch located in Crown Point wants to develop an improved process for serving customers during the noon-to-lpm lunch period. Management decides to first study the waiting time of the current process. Data is collected from a random sample of 15 customer and their waiting time is recorded (in minutes) and is located in the Excel data file for this assignment under the tab CPBank. For comparative purposes, similar data is collected from a bank in...
Create two excel graphs and descriptive statistics:
1 - Descriptive Statistics using data from attached file (Males)
and appropriate graph.
2 - Descriptive Statistics using data from attached file
(Females) and appropriate graph.
Create appropriate titles and grid lines Identify a variable to
be used as a basis for comparison between the two genders. Do not
use age or Blood Pressure. Create an appropriate graph. Are there
any outliers? Check for the outliers by creating the 5 number
summary doing...
1) Answer the question True or False. 1) Nonparametric methods focus on the location of the probability distribution, rather than on specific parameters of the population. A) True B) False 2) Nonparametric tests are useful for qualitative data that can be ranked. A) True B) False 3) The sign test provides inferences about the population median rather than the population mean. A) True B) False 4) For a sign test to be valid, a large sample must be selected from...
Please do all questions...
A cell phone battery manufacturer claims that one of their batteries for a particular cell phone will outperform a competitor's equivalent brand. To establish this claim, a researcher selected samples of the two brands of batteries and perform accelerated tests on them in the lab under identical conditions. A random sample of 55 of the manufacturer's battery was selected and placed on test. A corresponding random sample of 55 of the competitor's battery was also put...
Based on the Employment Situation Summary
below, answer the following questions:
1. What month (and year) is summarized?
What was the unemployment rate for that month?
How does that rate compare with the rate in the previous month?
2. What were the unemployment rates for adult women, teenagers,
blacks, hispanics, and whites?
How did these rates compare with those a month earlier?
3. What factors make it difficult to determine the unemployment
rate?
4. Why is unemployment an economic problem?...
Most questions answered within 3 hours.
-
Write the ionic equations for the first stage of salts
hydrolysis.
Anion, Cation?
Na2S
NiSO4
K2SO4...
asked 37 minutes ago -
suppose there is a normally distributed population with a mean of
250 and a standard deviation...
asked 1 hour ago -
Question Three
Suppose you as project manager are using the Waterfall
development methodology on a large...
asked 2 hours ago -
Which statement is not true about welfare in Canada?
A.Benefits typically vary based on one's ability...
asked 2 hours ago -
Please help me with FLOWCHART and UML diagram for class,
thank you!
#include <iostream>
#include <fstream>...
asked 3 hours ago -
3. Describe the “logic circuit” of the Lac operon. Which
proteins are bound or not to...
asked 3 hours ago -
Ayesha’s adjusted gross income is $60,000 in 2019. She donated a
piece of artwork with a...
asked 3 hours ago -
For Dijkstra’s shortest path algorithm:
a. Give the Big-O time for Dijkstra’s shortest path algorithm
and...
asked 3 hours ago -
Phosphorus violates the 'octet rule' in biological molecules,
forming more covalent bonds than expected based on...
asked 4 hours ago -
A 1.3 eV electron has a 10-4 probability of tunneling
through a 2.4 eV potential barrier....
asked 4 hours ago -
What is the one ingredient that is common to being successful
with all stakeholders?
profit
trust...
asked 4 hours ago -
Write an assembly language 32 bit program that reads in lines of
text by a .txt...
asked 4 hours ago