Question Attached - Rules Belowperform certain calculations discussed in the assigned reading in order to derive an answer for each problem.use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.to show all calculations or other work performed to derive your answer(s) for each problem.have your spreadsheet be fully functional (i.e., configured to allow the reader to not only see all numerical values, but also be able to see the underlying formula associated with each calculated value).to label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.No credit will be granted for problems that are not completed using Excel, for which your Excel worksheet is not fully functional, or for which you have not shown all of the calculations or other work performed to derive your answer(s). You may refer to the course textbooks, supplemental reading materials, online information, and your own notes in conjunction with completing the homework assignments. Once you have completed the necessary calculations to solve each problem and answer the associated questions, select the hyperlink provided to submit your Excel spreadsheet for grading.

Learn by DoingSome features of this activity may not work well on a cell phone or tablet. We highly recommend that you complete this activity on a computer.Here are the directions, grading rubric, and definition of high-quality feedback for the Learn by Doing discussion board exercises. A list of StatCrunch directions is provided at the bottom of this page.Variables Math: Math SAT score Verbal: Verbal SAT score Credits: Number of credits the student is registered for Year: Year in college (1=Freshman, 2=Sophomore, 3=Junior, 4=Senior) Exercise: Time (in minutes) spent exercising in a typical day Sleep: Time (in hours) spent sleeping in a typical day Veg: Are you a vegetarian (yes, no, some) Cell: Do you own a smart phone (yes, no)DataIf you have not done so already, download the cell-phones datafile. As always, if you are prompted to login, just close the prompt and continue with the download.Upload the datafile into StatCrunch. Note: the symbol * in the spreadsheet indicates a missing value; this means that the associated individual did not answer the question.ContextIn 2015 college students at a large state university completed a survey about their academic and personal life. Questions ranged from "How many credits are you registered for this semester?" to "Would you define yourself as a vegetarian?"The researcher randomly selected 325 students from the university; 312 responded to the survey.PromptThe cell-phone datafile is available in the Data section below.Once again, here is the research question for this lab.Based on a recent study, roughly 80% of college students in the U.S. own a smartphone. Is the proportion of smartphone owners lower at this university?Respond to each of the following in your initial post.State your hypotheses in symbolic form and in words. (The following should be clear in your answer: the population of interest and the meaning of the proportion p in terms of the variable Cell.)StatCrunch uses a normal model to estimate the P-value probability. Verify that normality conditions are met. Use StatCrunch to conduct the hypothesis test. (directions) Copy and paste the results (the StatCrunch output window) into your initial post.Give your P-value and interpret its meaning as a conditional probability.State a conclusion that answers the research question. Use a significance level of 5%. (Your answer should include the P-value and reference the population and the variable Cell.)