You will search for two quantitative variables that may have a linear correlation. You will describe and analyze the relationship between the variables.   

At the time she was hired as a server at the Grumney Family Restaurant, Beth Brigden was told, “You can average $88 a day in tips.” Assume the population of daily tips is normally distributed with a standard deviation of $2.50. Over the first 50 days she was employed at the restaurant, the mean daily amount of her tips was $89.93. At the 0.10 significance level, can Ms. Brigden conclude that her daily tips average more than $88?a.State the null hypothesis and the alternate hypothesis. H0: μ >88 ; H1: μ = 88H0: μ ≥ 88 ; H1: μ < 88H0: μ = 88 ; H1: μ ≠ 88H0: μ ≤ 88 ; H1: μ > 88b.State the decision rule. Reject H1 if z < 1.28Reject H1 if z > 1.28Reject H0 if z < 1.28Reject H0 if z > 1.28c.Compute the value of the test statistic. (Round your answer to 2 decimal places.) Value of the test statistic d.What is your decision regarding H0? Reject H0Do not reject H0e.What is the p-value? (Round your answer to 4 decimal places.) p-value 2.A sample of 39 observations is selected from a normal population. The sample mean is 31, and the population standard deviation is 5. Conduct the following test of hypothesis using the 0.05 significance level. H0 : μ ≤ 30H1 : μ > 30a.Is this a one- or two-tailed test? "Two-tailed"-the alternate hypothesis is different from direction."One-tailed"-the alternate hypothesis is greater than direction.b.What is the decision rule? (Round your answer to 3 decimal places.) (Click to select)RejectDo not reject H0, when z > c.What is the value of the test statistic? (Round your answer to 2 decimal places.) Value of the test statistic d.What is your decision regarding H0? Do not rejectRejectThere is (Click to select)insufficientsufficient evidence to conclude that the population mean is greater than 30.e.What is the p-value? (Round your answer to 4 decimal places.) p-value 3.The following information is available.H0 : μ ≥ 220H1 : μ < 220A sample of 64 observations is selected from a normal population. The sample mean is 215, and the population standard deviation is 15. Conduct the following test of hypothesis using the .025 significance level.a.Is this a one- or two-tailed test? Two-tailed testOne-tailed testb.What is the decision rule? (Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places.) (Click to select)RejectDo not reject H0 when z < c.What is the value of the test statistic? (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.) Value of the test statistic d.What is your decision regarding H0? RejectDo not rejecte.What is the p-value? (Round your answer to 4 decimal places.) p-value The amount of water consumed each day by a healthy adult follows a normal distribution with a mean of 1.50 liters. A sample of 10 adults after the campaign shows the following consumption in liters. A health campaign promotes the consumption of at least 2.0 liters per day: 1.52 1.64 1.66 1.40 1.82 1.70 1.90 1.45 1.78 1.92At the 0.010 significance level, can we conclude that water consumption has increased? Calculate and interpret the p-value. Click here for the Excel Data Filea.State the null hypothesis and the alternate hypothesis. (Round your answers to 2 decimal places.) H0: μ ≤ H1: μ > b.State the decision rule for 0.010 significance level. (Round your answer to 3 decimal places.) Reject H0 if t > c.Compute the value of the test statistic. (Round your intermediate and final answer to 3 decimal places.) Value of the test statistic d.At the 0.010 level, can we conclude that water consumption has increased? (Click to select)Fail to rejectReject H0 and conclude that water consumption has (Click to select)not increasedincreased.e.Estimate the p-value. p-value is(Click to select)between 0.0005 and 0.005between 0.01 and 0.025less than 0.0005between 0.005 and 0.01greater than 0.10between 0.05 and 0.10between 0.025 and 0.05 5.Watch Corporation of Switzerland claims that its watches on average will neither gain nor lose time during a week. A sample of 18 watches provided the following gains (+) or losses (–) in seconds per week. Click here for the Excel Data File–0.16–0.15–0.20–0.17+0.26–0.19+0.30+0.43–0.10–0.31–0.48–0.44–0.51–0.67–0.05–0.24–0.51+0.05a-1.Is it reasonable to conclude that the mean gain or loss in time for the watches is 0? Use the .05 significance level. At a level of .05 significance, we reject H0: μ = 0 if t < or t > . (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) a-2.The value of the test statistic is . (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.)a-3.(Click to select)RejectDo not reject H0: μ = 0. The p-value is (Click to select)greater than 0.20between 0.0100 and 0.020less than 0.001between 0.020 and 0.056.A United Nations report shows the mean family income for Mexican migrants to the United States is $28,540 per year. A FLOC (Farm Labor Organizing Committee) evaluation of 26 Mexican family units reveals a mean to be $30,500 with a sample standard deviation of $10,500. Does this information disagree with the United Nations report? Apply the 0.01 significance level.a.State the null hypothesis and the alternate hypothesis. H0: μ = H1: μ ≠ b.State the decision rule for .01 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) Reject H0 if t is not between and c.Compute the value of the test statistic. (Round your answer to 3 decimal places.) Value of the test statistic d.Does this information disagree with the United Nations report? Apply the 0.01 significance level. (Click to select)Do not reject HoReject Ho. This data (Click to select)contradictsdoes not contradict the report.7.A national grocer’s magazine reports the typical shopper spends 5 minutes in line waiting to check out. A sample of 15 shoppers at the local Farmer Jack’s showed a mean of 4.2 minutes with a standard deviation of 3.8 minutes. Is the waiting time at the local Farmer Jack’s less than that reported in the national magazine? Use the 0.010 significance level.a.What is the decision rule? (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.) Reject H0: µ ≥ 5 when the test statistic is (Click to select)greater thanless thanequal to . b.The value of the test statistic is . (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.)c.What is your decision regarding H0? Do not reject H0Reject H08.The American Water Works Association reports that the per capita water use in a single-family home is 80 gallons per day. Legacy Ranch is a relatively new housing development. The builders installed more efficient water fixtures, such as low-flush toilets, and subsequently conducted a survey of the residences. Twenty-six owners responded, and the sample mean water use per day was 78 gallons with a standard deviation of 7.2 gallons per day.At the 0.01 level of significance, is that enough evidence to conclude that residents of Legacy Ranch use less water on average?a.What is the decision rule? (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.) Reject H0: µ ≥ 80 when the test statistic is (Click to select)less thanmore than .b.The value of the test statistic is . (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.)c.What is your decision regarding H0? RejectFail to reject

Assignment ContentPurpose  This assignment illustrates how data analytics can be used to create strategies for sustainable organizational success while integrating the organization’s mission with societal values. You’ll apply statistical time series modeling techniques to identify patterns and develop time-dependent demand models. You’ll practice organizing and delivering a presentation to senior decision-makers. The PowerPoint presentation includes an audio component in addition to speaker notes. Resources: Microsoft Excel®, DAT565_v3_Wk6_Data_File Scenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid. You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city. Instructions: Work with the provided Excel database. This database has the following columns:LotCode: A unique code that identifies the parking lotLotCapacity: A number with the respective parking lot capacityLotOccupancy: A number with the current number of cars in the parking lotTimeStamp: A day/time combination indicating the moment when occupancy was measuredDay: The day of the week corresponding to the TimeStampInsert a new column, OccupancyRate, recording occupancy rate as a percentage with one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%).Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected?Using the OccupancyRate and LotCode columns,construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates?Are some parking lots more frequented than others? Is this what you expected?Select any 2 parking lots. For each one, prepare as scatter plot showing occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are occupancy rates time dependent? If so, which times seem to experience highest occupancy rates? Is this what you expected?Presentation: Create a 10- to 12-slide presentation with speaker notes and audio. Your audience is the City Council members who are responsible for deciding whether the city invests in resources to set in motion the smart parking space app. Complete the following in your presentation: Outline the rationale and goals of the project. Utilize boxplots showing the occupancy rates for each day of the week. Include your interpretation of results.Utilize box plots showing the occupancy rates for each parking lot. Include your interpretation of results.Provide scatter plots showing occupancy rate against time of day of your selected four parking lots. Include your interpretation of results. Make a recommendation about continuing with the implementation of this project.