video1.0<iframe src="https://www.loom.com/embed/12b042344c3e446e8470b3017a2261a2" frameborder="0" width="1108" height="831" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>8311108Loomhttps://www.loom.com8311108https://cdn.loom.com/sessions/thumbnails/12b042344c3e446e8470b3017a2261a2-8b5f7148df2b5827.gif1060.81This 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.