Business Intelligence discussion board
January 11, 2023
Week 2 Case Study 1: The Brazilian Federal Data Processing Service
January 11, 2023

pls help me

A consumer advocate researches the length of life between two brands of refrigerators, Brand A and Brand B. He collects data on the longevity of 40 refrigerators for Brand A and repeats the sampling for Brand B. These data are measured in years and can be found on the text website, labeled Refrigerator Longevity. Let Brands A and B represent populations 1 and 2, respectively. Use Table 1.Brand ABrand BBrand ABrand B2521181915152419241517172419182212241919251918252021232219191215241924151215182418202515192317121519142314131325141716212214212312171324211720161314201319162025Click here for the Excel Data Filea.Specify the competing hypotheses to test whether the average length of life differs between the two brands.[removed]H0: μ1 − μ2 ≥ 0; HA: μ1 − μ2 < 0[removed]H0: μ1 − μ2 ≤ 0; HA: μ1 − μ2 > 0[removed]H0: μ1 − μ2 = 0; HA: μ1 − μ2 ≠ 0b.Using the appropriate commands in Excel, find the value of the test statistic. Assume that σA2 = 4.6 and σB2 = 5.3. What is the p-value? (Negative values should be indicated by a minus sign. Do not round intermediate calculations. Round “test statistic” value to 2 decimal places and “p-value” to 4 decimal places.)Test statistic[removed]p-value[removed]c.At the 5% significance level, what is the conclusion?[removed]Reject H0, the average life does not differ between the brands.[removed]Do not reject H0, the average life differs between the brands.[removed]Do not reject H0, the average life does not differ between the brands.[removed]Reject H0, the average life differs between the brands.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.