Mathematics
Statistical Foundations for Business Analytics Questions

### Question Description

I’m studying for my Mathematics class and need an explanation.

The question is based for Statistical Foundations for Business analytics. Please do in the right way by use excel calculate

### Unformatted Attachment Preview

QUESTION 1 Are nursing hourly pay in Tampa, Florida lower than in Dallas, Texas? The data is shown below: Tampa: sample mean = 39, sample standard deviation = 6.2, sample size = 42 Dallas: sample mean = 48, sample standard deviation = 6.3, sample size = 33 Provide the test statistics value for the analysis. QUESTION 2 The director of a green energy company is interested in comparing two different methods of installing solar light panels. An experiment is conducted with 41 technicians using the old method and the other 46 technicians using the new method. For the 41 technicians using the old method, the average time was 543 minutes with 77.9 standard deviation. For the 46 technicians using the new method, the average time was 473 minutes with 100.2 standard deviation. Conduct an analysis to determine whether there is a difference in the average time to complete the installation of the solar panels. Provide the degrees of freedom. QUESTION 3 We are interested in studying whether Private Colleges costs at least \$15,000 more than Public Colleges. This is to run an advertisement campaign to promote more high school students to consider public colleges to save at least \$15,000 in tuition a year. See the excel file CollegeCosts for the random samples showing the annual cost of attending private and public colleges. Data are in thousands of dollars. What is the p-value for this hypothesis testing. Hint: This is a challenging question. It is indeed a t-test 2 sample unequal variance question. But the hypothesized mean difference should have been “15” because the question wants to analyze: "We are interested in studying whether Private Colleges costs at least \$15,000 more than Public Colleges.” Since the data is in thousands, we would enter in 15 for the hypothesized mean difference. QUESTION 4 The data file ExamScores shows the 40 students in a TOM 3010 course exam scores for the Midterm and Final exam. Is there statistically significant evidence to show that students score lower on their final exam than midterm exam? Provide the p-value for this analysis. QUESTION 5 Of 200 subjects approached by Interviewer A, 51 refused to be interviewed. Of 120 subjects approached by interviewer B, 49 refused an interview. Can we reject the possibility that the two interviewers are equally capable of obtaining interviews? Provide the test statistics value from your analysis. QUESTION 6 A telephone sales solicitor, trying to decide between two alternative sales pitches, randomly alternate between them during a day of calls. The following table provides the proportion of people interested in the product. % Interested # of Calls Approach A Approach B 21% 15% 100 100 Conduct a hypothesis testing to determine whether there is a difference in the proportions of those interested based on the sales pitch. Provide the test statistics value from your analysis. ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Hello again! So herewith are my answers highlighted in green.

QUESTION 1
Are nursing hourly pay in Tampa, Florida lower than in Dallas, Texas? The data is shown below:
Tampa: sample mean = 39, sample standard deviation = 6.2, sample size = 42
Dallas: sample mean = 48, sample standard deviation = 6.3, sample size = 33
Provide the test statistics value for the analysis.

The two samples are independent of each other. However, if we test for variance using F-test, the
result would be equal variances.
Equal Variances Test Statistics Value = -6.1962
But based on the notes, unequal variances are assumed.
Unequal Variances Test Statistics Value = -6.1842

QUESTION 2
The director of a green energy company is interested ...

elaineaverion (1607)
Purdue University
Review
Review

Anonymous
The tutor managed to follow the requirements for my assignment and helped me understand the concepts on it.

Anonymous
The tutor was knowledgeable, will be using the service again.

Anonymous
Awesome quality of the tutor. They were helpful and accommodating given my needs.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4