Cashback Offer from 12th to 18th November 2021. Get Flat 10% Cashback credited to your account for a minimum transaction of \$80. Post Your Question Today!

Question DetailsNormal
\$ 35.00

# Data analysis toolpack

Question posted by

PROBLEM:

To answer this question, use the Data Analysis Toolpack in Excel and select “t-Test: Two-Sample

Assuming Equal Variances” from the list of available tools. Explain your answer (how did you decide if

men spend more) and include the output table.

Some studies have shown that in the United States, men spend more than women buying gifts and cards on Valentine’s Day. Suppose a researcher wants to test this hypothesis by randomly sampling nine men and 10 women with comparable demographic characteristics from various large cities across the United States to be in a study. Each study participant is asked to keep a log beginning one month before Valentine’s Day and record all purchases made for Valentine’s Day during that one-month period. The resulting data are shown below. Use these data and a 1% level of significance to test to determine if, on average, men actually do spend significantly more than women on Valentine’s Day. Assume that such spending is normally distributed in the population and that the population variances are equal.

Men                Women

107.48             125.98

143.61              45.53

90.19                56.35

125.53              80.62

70.79                46.37

83.00                 44.34

129.63              75.21

154.22               68.48

93.80                85.84

126.11

The following pages shows the answered I received with clear process, solutions and comparisons, but instead putting 9 men entries and 10 women; he put it opposite.  Please correct entries and results.

The observations are wrong there are 9 men and 10 women

t-Test: Two-Sample Assuming Equal Variances

Men

Women

Mean

112.436

69.85778

Variance

759.9333378

691.0798

Observations

10

9

Pooled Variance

727.5316939

Hypothesized Mean Difference

0

Df

17

t Stat

3.4356271

P(T<=t) one-tail

0.001577404

t Critical one-tail

1.739606716

P(T<=t) two-tail

0.003154808

t Critical two-tail

2.109815559

\$ 35.00

## [Solved] data analysis toolpack

• This solution is not purchased yet.
• Submitted On 25 Nov, 2015 03:48:37
PROBLEM: To answer this question, use the Data Analysis Toolpack in Excel and select “t-Test: Two-Sample Assuming Equal Variances” from the list of available tools. Explain your answer (how did you decide if men spend more) and include the output table. Some studies have shown that in the United States, men spend more than women buying gifts and cards on Valentine’s Day. Suppose a researcher wants to test this hypothesis by randomly sampling nine men and 10 women with comparable demogr...
Buy now to view the complete solution
Attachment
Other Similar Questions
charl...

### Chapter 14 Big Data Analytics and NoSQL

Big Data Analytics and NoSQL 462 Discussion Focus Start by explaining that Big Data is a nebulous term. Its definition and the composition of the techniques and technologies that are covered under this umbrella term are ...

### DAT 565 University of Phoenix Data Analysis And Business Analytics Discussion

Purpose  This assignment is intended to give you an opportunity to strengthen your skills in gathering and analyzing business-related information. It provides a deeper understanding of how companies can look at globaliza...
termp...

### BUS307 WEEK 3 Assignment.docx RUNNING HEAD: DATA ANALYSIS, SPEND ANALYSIS AND SIX

BUS307 WEEK 3 Assignment.docx RUNNING HEAD: DATA ANALYSIS, SPEND ANALYSIS AND SIX SIGMA BUS 307 Data Analysis, Spend Analysis and Six Sigma: Making a Business Successful University Arizona Global Campus BUS 307: O...
Quali...

### MGT 6203 Week 12 Self Assessment 7 - Data Analytics Business. Latest 2021

MGT 6203 Week 12 Self Assessment 7 - Data Analytics Business. Latest 2021.Due Apr 10 at 11:59pm Points 10 Questions 10 Available Mar 20 at 8am - Apr 10 at 11:59pm 22 days Time Limit None Allowed Attempts Unlimited I...
termp...

### PSY325week1Assignment.docx Chi-Square Data Analysis PSY325: Statistics for the Behavio

PSY325week1Assignment.docx Chi-Square Data Analysis PSY325: Statistics for the Behavioral & Social Sciences Introduction There have been many studies showing relevance between students' grades and how students evalua...

#### The benefits of buying study notes from CourseMerit

##### Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
##### Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.