Question

In: Math

Conduct a hypothesis test to determine if  companies with negative revenue change tend to be on the...

Conduct a hypothesis test to determine if  companies with negative revenue change tend to be on the (500) market less time (and/or how much less time)?

The data is below. Please show all work in excel.

Company Name Revenue Change # Years on Fortune 500 List
Walmart 3.00% 24
Exxon Mobil 17.40% 24
Berkshire Hathaway 8.30% 24
Apple 6.30% 24
UnitedHealth Group 8.80% 24
McKesson 3.10% 24
CVS Health 4.10% 24
Amazon.com 27.10% 17
AT&T -2.00% 24
General Motors -5.50% 24
Ford Motor 3.30% 24
AmerisourceBergen 4.30% 24
Chevron 25.10% 24
Cardinal Health 6.90% 24
Costco 8.70% 24
Verizon 0.00% 24
Kroger 6.40% 24
General Electric -3.50% 24
Walgreens Boots Alliance 0.70% 24
JPMorgan Chase 8.00% 24
Fannie Mae 4.90% 21
Alphabet 22.80% 13
Home Depot 6.70% 24
Bank of America Corp. 7.00% 24
Express Scripts Holding -0.20% 19
Wells Fargo 3.80% 24
Boeing -1.20% 24
Phillips 66 26.50% 6
Anthem 6.10% 24
Microsoft 5.40% 24
Valero Energy 26.00% 20
Citigroup 6.80% 24
Comcast 5.10% 23
IBM -1.00% 24
Dell Technologies 21.40% 21
State Farm Insurance Cos. 2.90% 24
Johnson & Johnson 6.30% 24
Freddie Mac 13.70% 21
Target 3.40% 24
Lowes 5.50% 24
Marathon Petroleum 21.00% 7
Procter & Gamble -7.70% 24
MetLife 4.20% 24
UPS 8.20% 24
PepsiCo 1.20% 24
Intel 5.70% 24
DowDuPont 30.20% 24
Archer Daniels Midland -2.40% 24
Aetna -4.10% 18
FedEx 19.80% 24
United Technologies 4.50% 24
Prudential Financial 1.50% 24
Albertsons Cos. 1.60% 14
Sysco 9.90% 24
Disney -0.90% 24
Humana -1.10% 24
Pfizer -0.50% 24
HP 7.90% 24
Lockheed Martin 0.80% 24
AIG -5.40% 24
Centene 19.30% 9
Cisco Systems -2.50% 22
HCA Healthcare 6.50% 24
Energy Transfer Equity 26.60% 12
Caterpillar 18.00% 24
Nationwide 9.60% 24
Morgan Stanley 15.00% 24
Liberty Mutual Insurance Group 11.40% 24
New York Life Insurance 3.70% 24
Goldman Sachs Group 12.00% 19
American Airlines Group 5.00% 24
Best Buy 7.00% 24
Cigna 4.90% 24
Charter Communications 43.40% 18
Delta Air Lines 4.00% 24
Facebook 47.10% 6
Honeywell International 3.10% 24
Merck 0.80% 24
Allstate 5.40% 23
Tyson Foods 3.70% 24
United Continental Holdings 3.20% 24
Oracle 1.80% 23
Tech Data 40.20% 24
TIAA -2.90% 21
TJX 8.10% 24
American Express 5.20% 24
Coca-Cola -15.40% 24
Publix Super Markets 1.60% 24
Nike 6.10% 24
Andeavor 42.50% 19
World Fuel Services 24.70% 14
Exelon 6.90% 24
Massachusetts Mutual Life Insurance -11.40% 24
Rite Aid 6.90% 24
ConocoPhillips 33.80% 24
CHS 5.20% 19
3M 5.10% 24
Time Warner 6.70% 19
General Dynamics -1.20% 24
USAA 10.60% 24

Solutions

Expert Solution

First sort the table based on revenue

and make two new columns for years based on positive and negative revenues

data -> sort

Company Name Revenue Change # Years on Fortune 500 List
Coca-Cola -15.40% 24
Massachusetts Mutual Life Insurance -11.40% 24
Procter & Gamble -7.70% 24
General Motors -5.50% 24
AIG -5.40% 24
Aetna -4.10% 18
General Electric -3.50% 24
TIAA -2.90% 21
Cisco Systems -2.50% 22
Archer Daniels Midland -2.40% 24
AT&T -2.00% 24
Boeing -1.20% 24
General Dynamics -1.20% 24
Humana -1.10% 24
IBM -1.00% 24
Disney -0.90% 24
Pfizer -0.50% 24
Express Scripts Holding -0.20% 19
Verizon 0.00% 24
Walgreens Boots Alliance 0.70% 24
Lockheed Martin 0.80% 24
Merck 0.80% 24
PepsiCo 1.20% 24
Prudential Financial 1.50% 24
Albertsons Cos. 1.60% 14
Publix Super Markets 1.60% 24
Oracle 1.80% 23
State Farm Insurance Cos. 2.90% 24
Walmart 3.00% 24
McKesson 3.10% 24
Honeywell International 3.10% 24
United Continental Holdings 3.20% 24
Ford Motor 3.30% 24
Target 3.40% 24
New York Life Insurance 3.70% 24
Tyson Foods 3.70% 24
Wells Fargo 3.80% 24
Delta Air Lines 4.00% 24
CVS Health 4.10% 24
MetLife 4.20% 24
AmerisourceBergen 4.30% 24
United Technologies 4.50% 24
Fannie Mae 4.90% 21
Cigna 4.90% 24
American Airlines Group 5.00% 24
Comcast 5.10% 23
3M 5.10% 24
American Express 5.20% 24
CHS 5.20% 19
Microsoft 5.40% 24
Allstate 5.40% 23
Lowes 5.50% 24
Intel 5.70% 24
Anthem 6.10% 24
Nike 6.10% 24
Apple 6.30% 24
Johnson & Johnson 6.30% 24
Kroger 6.40% 24
HCA Healthcare 6.50% 24
Home Depot 6.70% 24
Time Warner 6.70% 19
Citigroup 6.80% 24
Cardinal Health 6.90% 24
Exelon 6.90% 24
Rite Aid 6.90% 24
Bank of America Corp. 7.00% 24
Best Buy 7.00% 24
HP 7.90% 24
JPMorgan Chase 8.00% 24
TJX 8.10% 24
UPS 8.20% 24
Berkshire Hathaway 8.30% 24
Costco 8.70% 24
UnitedHealth Group 8.80% 24
Nationwide 9.60% 24
Sysco 9.90% 24
USAA 10.60% 24
Liberty Mutual Insurance Group 11.40% 24
Goldman Sachs Group 12.00% 19
Freddie Mac 13.70% 21
Morgan Stanley 15.00% 24
Exxon Mobil 17.40% 24
Caterpillar 18.00% 24
Centene 19.30% 9
FedEx 19.80% 24
Marathon Petroleum 21.00% 7
Dell Technologies 21.40% 21
Alphabet 22.80% 13
World Fuel Services 24.70% 14
Chevron 25.10% 24
Valero Energy 26.00% 20
Phillips 66 26.50% 6
Energy Transfer Equity 26.60% 12
Amazon.com 27.10% 17
DowDuPont 30.20% 24
ConocoPhillips 33.80% 24
Tech Data 40.20% 24
Andeavor 42.50% 19
Charter Communications 43.40% 18
Facebook 47.10% 6
negative positive
24 24
24 24
24 24
24 24
24 24
18 24
24 14
21 24
22 23
24 24
24 24
24 24
24 24
24 24
24 24
24 24
24 24
19 24
24
24
24
24
24
24
21
24
24
23
24
24
19
24
23
24
24
24
24
24
24
24
24
24
19
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
19
21
24
24
24
9
24
7
21
13
14
24
20
6
12
17
24
24
24
19
18
6

data -> data analysis -> t-Test: Two-Sample Assuming Equal Variances

t-Test: Two-Sample Assuming Equal Variances
negative positive
Mean 23.11111111 22.04878049
Variance 3.516339869 19.08401084
Observations 18 82
Pooled Variance 16.38349649
Hypothesized Mean Difference 0
df 98
t Stat 1.0083
P(T<=t) one-tail 0.1579
t Critical one-tail 1.6606
P(T<=t) two-tail 0.3158
t Critical two-tail 1.9845

this is left tailed test

p-value = 0.1579 > alpha

hence we fail to reject the null hypothesis

we conclude that there is not sufficient evidence


Related Solutions

Please conduct a Hypothesis test in the following scenario to determine if the population slope is...
Please conduct a Hypothesis test in the following scenario to determine if the population slope is statistically significant. State the appropriate test statistic, the critical values, and whether or not you can reject a null hypothesis that the population slope is zero. Use a 1% significance level. Suppose that you collected data to determine the relationship between the amount of time a person spends online as an independent variable and the amount of money a person spends online as the...
We would like to conduct a hypothesis test at the 5% level of significance to determine...
We would like to conduct a hypothesis test at the 5% level of significance to determine whether hockey players weigh more on average than baseball players. We record the weights of a random sample of 12 professional hockey players and 7 professional baseball players. Weights of athletes in both sports are known to follow normal distributions. Some summary statistics are given below: Sport n x s d Baseball 7 187.571 7.72 Hockey 12 195.583 18.39 Based on the data, we...
Conduct a test of hypothesis to determine whether the mean salary (Salary column) of the teams...
Conduct a test of hypothesis to determine whether the mean salary (Salary column) of the teams was different than $75.0 million. Use the 5% level of significance. Note: We do not know the populations standard deviation. Salary 93.6 143 108.7 61.7 95.2 67.1 103.9 71.4 189.6 79.4 106.5 24.1 68.3 89.1 66.2 87.3 99.7 68.9 54.4 30.5 87.8 108.5 71 115.2 89.4 38.5 58.1 90.2 90.3 37.3 Select one: a. p = 19.2%. Do not reject the null. The mean...
Use the data from question 1. Conduct a hypothesis test at α = .01 to determine...
Use the data from question 1. Conduct a hypothesis test at α = .01 to determine if the population variance is greater than 904.75. Question 1: 1. Consider the following sampled data: s 2 = 906.304, n = 31. Calculate the following confidence intervals for the population variance: (a) 90% (b) 95% (c) 99%
If we were to conduct a hypothesis test to test if a population proportion of a...
If we were to conduct a hypothesis test to test if a population proportion of a certain event is 0.2 versus the alternative that it is greater than 0.2 and we sampled 100 people, what would the probability of a Type I Error be if we were to use the arbitrary decision rule to reject Ho if more than 30 units in the sample had the event (not the way we tested hypotheses in class)? What would the probability of...
Conduct a hypothesis test (using either the p-Value Approach or the Critical Value Approach) to determine...
Conduct a hypothesis test (using either the p-Value Approach or the Critical Value Approach) to determine if the proportion of all recent clients is more dissatisfied than the traditional level of dissatisfaction. Use α = 0.08. Do not forget to include the correctly worded hypotheses and show all the steps required to conduct the hypothesis test. 92 out of sample of 200 were dissatisfied
Hypothesis test. Using the p-value method,conduct a formal hypothesis test of the claim that the mean...
Hypothesis test. Using the p-value method,conduct a formal hypothesis test of the claim that the mean RBG of Type 2 diabetics is 13.5 mmol/dl or higher. Use = 0.01. Include the following in your written summary of the results: Your null and alternate hypotheses in the proper format using standard notation. The type of distribution you used ( or normal). The p-value and its logical relationship to (≤ or >). Your decision regarding the null hypothesis: reject or fail to...
Conduct the hypothesis test and provide the test statistic and the critical​ value, and state the...
Conduct the hypothesis test and provide the test statistic and the critical​ value, and state the conclusion. A person purchased a slot machine and tested it by playing it 1,156 times. There are 10 different categories of​ outcomes, including no​ win, win​ jackpot, win with three​ bells, and so on. When testing the claim that the observed outcomes agree with the expected​ frequencies, the author obtained a test statistic of chi squared equals18.233. Use a 0.05 significance level to test...
Conduct the hypothesis test and provide the test statistic and the critical value, and state the...
Conduct the hypothesis test and provide the test statistic and the critical value, and state the conclusion. A person drilled a hole in a die and filled it with a lead weight, then proceeded to roll it 200 times. Here are the observed frequencies for the outcomes of 1, 2, 3, 4, 5, and 6, respectively: 28, 27, 40, 38, 26, 41. Use a 0.01 significance level to test the claim that the outcomes are not equally likely. Does it...
Conduct the hypothesis test and provide the test statistic and the critical? value, and state the...
Conduct the hypothesis test and provide the test statistic and the critical? value, and state the conclusion. A company claims that its packages of 100 candies are distributed with the following color? percentages: 13?% red, 22?%? orange, 16?%? yellow, 8?%? brown, 23?% blue, and 18?% green. Use the given sample data to test the claim that the color distribution is as claimed. Use a 0.10 significance level. candy count color number in package red 12 orange 25 yellow 8 brown...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT