Question

In: Statistics and Probability

2.   Data, which may be found in the Excel file named “Luggage” on the course Canvas...

2.   Data, which may be found in the Excel file named “Luggage” on the course Canvas Site (Chapter 10 Data Files), gives the weights (in pounds) of randomly selected checked bags for an airline’s International and Domestic flights on the same day.

    • First, test to determine if the variances in weights of checked bags differ between international and domestic flights. Show and follow the 7 steps for hypothesis testing. (8 points)
    • Verify your results in part a. using Minitab; attach or include your output. (3 points)
    • Using the information from your test results in part a., test to determine if the average weight for bags on an international flight is greater than the average weight for bags on a domestic flight. (8 points).
    • Refer to part c., give and interpret the p-value using probabilities. (4 points)
    • Verify your results in part c., using Minitab; attach or include your output. (3 points)
    • International Domestic
      39 29
      54 36
      46 33
      39 34
      69 38
      47 37
      48 33
      28 29
      54 43
      62 39
      43
      42
      32
      35
      39

Solutions

Expert Solution

  

________________________________

_________________________________

_________________________________

_________________________________

5. Decision = Reject Ho, Since 6.74 is greater than 3.21

________________________________

6 . P-value = 0.002

________________________________

7. Conclusion = we have enough evidence to conclude that population variances are not equal.

___________________________________

Minitab output

Test and CI for Two Variances: International, Domestic

Method

σ₁: standard deviation of International
σ₂: standard deviation of Domestic
Ratio: σ₁/σ₂
F method was used. This method is accurate for normal data only.

Descriptive Statistics

Variable N StDev Variance 95% CI for σ²
International 10 11.890 141.378 (66.888, 471.191)
Domestic 15 4.580 20.981 (11.246, 52.185)

Ratio of Variances

Estimated
Ratio
95% CI for
Ratio using F
6.73839 (2.100, 25.592)

Test

Null hypothesis H₀: σ₁² / σ₂² = 1
Alternative hypothesis H₁: σ₁² / σ₂² ≠ 1
Significance level α = 0.05
Method Test
Statistic
DF1 DF2 P-Value
F 6.74 9 14 0.002

Test and CI for Two Variances: International, Domestic

_____________________________________________________________

____________________________________________________________

2.

Two-Sample T-Test and CI: International, Domestic

Method

μ₁: mean of International
µ₂: mean of Domestic
Difference: μ₁ - µ₂

Equal variances are not assumed for this analysis.

Descriptive Statistics

Sample N Mean StDev SE Mean
International 10 48.6 11.9 3.8
Domestic 15 36.13 4.58 1.2

Estimation for Difference

Difference 95% Lower Bound
for Difference
12.47 5.32

Test

Null hypothesis H₀: μ₁ - µ₂ = 0
Alternative hypothesis H₁: μ₁ - µ₂ > 0
T-Value DF P-Value
3.16 10 0.005

Since p-value is less than 0.05 so, reject the null hypothesis and we can conclude that the International mean is greater than Domestic mean


Related Solutions

2.   Data, which may be found in the Excel file named “Luggage” on the course Canvas...
2.   Data, which may be found in the Excel file named “Luggage” on the course Canvas Site (Chapter 10 Data Files), gives the weights (in pounds) of randomly selected checked bags for an airline’s International and Domestic flights on the same day. First, test to determine if the variances in weights of checked bags differ between international and domestic flights. Show and follow the 7 steps for hypothesis testing. (8 points) Verify your results in part a. using Minitab; attach...
2.   Data, which may be found in the Excel file named “Luggage” on the course Canvas...
2.   Data, which may be found in the Excel file named “Luggage” on the course Canvas Site (Chapter 10 Data Files), gives the weights (in pounds) of randomly selected checked bags for an airline’s International and Domestic flights on the same day. First, test to determine if the variances in weights of checked bags differ between international and domestic flights. Show and follow the 7 steps for hypothesis testing. (8 points) Verify your results in part a. using Minitab; attach...
Use the Excel data file found in the Course Content from Module #1. Be sure to...
Use the Excel data file found in the Course Content from Module #1. Be sure to submit your file through the Project #4 drop box for this week. Masterfoods USA states that their color blends were selected by conducting consumer preference tests, which indicated the assortment of colors that pleased the greatest number of people and created the most attractive overall effect. On average, they claim the following percentages of colors for M&Ms® milk chocolate candies: 24% blue, 20% orange,...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run the descriptive statistics for BMI (Body Mass Index) and SysBP (Systolic Blood Pressure), including graphing a scatter plot of BMI by SysBP. Calculate the correlation between BMI and SysBP. Calculate the regression with SysBP as the response variable (y) and BMI as the explanatory (sometimes called “Independent”) variable (x). In other words, we want to see how much BMI predicts SysBP. Is there a...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run descriptive statistics for all the groups. Calculate an equal variance independent samples t-test for SysBP1 vs. SysBP2. Run an ANOVA for just SysBP1 and SysBP2. Note how the results of the t-test and ANOVA compare. Run an ANOVA using all three groups. If you reject the null hypothesis, use the post hoc analysis shown in the Activity 3 Excel file SysBP1 148 114 120...
In PowerShell ISE create a script. Use the text file “its3410Users.txt” (found on Canvas) and import...
In PowerShell ISE create a script. Use the text file “its3410Users.txt” (found on Canvas) and import the users into your domain controller. The user file has a first name, last name, and department. Using this information, create users with the following specifications: Username will be first name.last name User Principal Name will be first name.last [email protected] The department signifies the OU that the user will be placed into If the department does not exist, create it Fill in the first...
2) Using the excel data file “shopping” which shows the reasons American and East Asian students...
2) Using the excel data file “shopping” which shows the reasons American and East Asian students from a large Midwestern university may buy from catalogs. a) (10 pts) For the Asian students make a pie chart of the reason they buy using a catalog. (Hint you will need to weigh cases by Asian) b) (10 pts) Make a bar chart showing the counts for the reasons American students buy using a catalog. (Hint you will need to weigh cases by...
1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet, select...
1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet, select the range A4:G4, wrap the text, apply Center alignment, and apply Blue, Accent 5, Lighter 60% fill color. 3 On the DC worksheet, merge and center the title in the range A1:G1. Apply Accent5 cell style and bold to the title. 4 On the DC worksheet, change the width of column A to 34. 5 On the DC worksheet, select the range C5:F10 and...
Find the data for the problem in the first worksheet named LightbulbLife of the data file....
Find the data for the problem in the first worksheet named LightbulbLife of the data file. It gives the data on the lifetime in hours of a sample of 100 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for this study. Can this lightbulb manufacturer claim at a significance level of 5% that...
Question 2: Download the Excel data file "Arlington_Homes" from the folder "Data" under "Chapter 12." a)...
Question 2: Download the Excel data file "Arlington_Homes" from the folder "Data" under "Chapter 12." a) read the data file in R. b) using R, answer question 65 (a, b, and c) on page 411 of your book. Run the regression, show the estimates and test. Write what you are testing using a comment in the R program. Question #65. link for page 411 #65 https://imgur.com/s0SgxP3 please show every step for R frmulas Price Sqft Beds Baths Col 840000 2768...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT