{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/12b042344c3e446e8470b3017a2261a2\" frameborder=\"0\" width=\"1108\" height=\"831\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":831,"width":1108,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":831,"thumbnail_width":1108,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/12b042344c3e446e8470b3017a2261a2-8b5f7148df2b5827.gif","duration":1060.81,"title":"Su26 - QBA1720 - EL#3 - ZTest - Reds - Tab 3","description":"This Loom explains how to complete a two-tailed hypothesis test to determine whether REZ ticket prices differ from the MLB average. The MLB population mean is $38 with a standard deviation of $9.50, and the sample uses 45 REZ ticket games to test at alpha 5% using a critical value split left and right. It computes the standard error as sigma over square root of n, finds left and right critical Z values using Norm.S.Inv, calculates the test Z score and the p value using Norm.S.Distribution with a left-tail for a negative Z. The conclusion rejects the null because the p value (0.248) is lower than alpha, concluding the REZ ticket prices are less than the MLB average, with a 95% confidence interval reported between the lower and upper bounds."}