{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T03:12:23-04:00", "answer_date": "2024-06-28 03:12:23", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4228666", "url": "\/study-help\/questions\/please-provide-a-stepbystep-of-excel-formulas-for-each-problem-4228666", "question_creation_date_js": "2024-06-28T03:12:23-04:00", "question_creation_date": "Jun 28, 2024 03:12 AM", "meta_title": "[Solved] ***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL | SolutionInn", "meta_description": "Answer of - ***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL FORMULAS FOR EACH PROBLEM - ATTACHED IS A GOOGLE SHEETS FOR REFERENCE, SCREE | SolutionInn", "meta_keywords": "***,provide,step--step,excel,formulas,problem,-,attached,google,sheets,reference,screenshots", "question_title_h1": "***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL FORMULAS FOR EACH PROBLEM - ATTACHED IS A GOOGLE SHEETS FOR REFERENCE, SCREENSHOTS WITH FORMULAS PLEASE*** ****THANK YOU!!!**** https:\/\/docs.google.com\/spreadsheets\/d\/1Zaw8NijWXggl0IQ_sHXoCZCfMd5EuAuFd87aXKupWzg\/edit?usp=sharing", "question_title": "***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL FORMULAS FOR EACH PROBLEM - ATTACHED", "question_title_for_js_snippet": " PLEASE PROVIDE A STEP BY STEP OF EXCEL FORMULAS FOR EACH PROBLEM ATTACHED IS A GOOGLE SHEETS FOR REFERENCE, SCREENSHOTS WITH FORMULAS PLEASE THANK YOU https docs google com spreadsheets d 1Zaw8NijWXggl0IQ sHXoCZCfMd5EuAuFd87aXKupWzg edit usp sharing 1 You want to rent an unfurnished one bedroom apartment in Durham, NC, next year The mean monthly rent for a random sample of 50 apartments advertised on Craig's List (a website that lists apartments for rent) is $1000 Assume a population standard deviation of $200 Construct a 95 confidence interval 2 Unoccupied seats on flights cause airlines to lose revenue Suppose a large airline wants to estimate its mean number of unoccupied seats per flight over the past year To accomplish this, the records of 225 flights are randomly selected and the number of unoccupied seats is noted for each of the sampled flights The sample mean is 11 6 seats and the sample standard deviation is 4 2 seats Construct a 95 confidence interval 3 A professor wants to know if her introductory statistics class has a good grasp of basic math Eight students are chosen at random from the class and given a math proficiency test The professor wants the class to be able to score above 70 on the test The sample mean score of the six students is 79 with a sample standard deviation of 12 931 Can the professor have 95 confidence that the mean score for the class on the test would be above 70 Formulate the hypothesis, compute the test statistic, find the critical value, and draw a conclusion 4 Suppose a consumer group suspects that the proportion of households that have three cell phones is 30 A cell phone company has reason to believe that the proportion is not 30 Before they start a big advertising campaign, they conduct a hypothesis test Their marketing people survey 150 households with the result that 46 of the households have three cell phones For the hypothesis test, use a 5 level of significance Formulate the hypothesis, compute the test statistic, find the critical value, and draw a conclusion 5 The administration at a college wishes to estimate, the proportion of all its entering freshmen who graduate within four years, with 95 confidence Estimate the minimum size sample required Assume that the population standard deviation is 0 25 and precision level is 0 03 6 Using the student grades data below, construct a scatter chart for midterm versus final exam grades and add a linear trendline What is the regression model If a student scores 75 on the midterm, what would you predict their grade on the final exam to be 7 Forecast the IBM stock prices shown below using a two period moving average Compute MAD, MSE, and MAPE 8 Forecast the DJ Industrials Index data shown below using simple exponential smoothing with a smoothing constant of 0 4 ", "question_description": "

***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL FORMULAS FOR EACH PROBLEM - ATTACHED IS A GOOGLE SHEETS FOR REFERENCE, SCREENSHOTS WITH FORMULAS PLEASE***<\/strong> ****THANK YOU!!!****<\/p>

<\/p>

https:\/\/docs.google.com\/spreadsheets\/d\/1Zaw8NijWXggl0IQ_sHXoCZCfMd5EuAuFd87aXKupWzg\/edit?usp=sharing<\/p>

<\/p>

1. You want to rent an unfurnished one-bedroom apartment in Durham, NC, next year. The mean monthly rent for a random sample of 50 apartments advertised on Craig's List (a website that lists apartments for rent) is $1000. Assume a population standard deviation of $200. Construct a 95% confidence interval.<\/strong><\/p>

<\/p>

2.Unoccupied seats on flights cause airlines to lose revenue. Suppose a large airline wants to estimate its mean number of unoccupied seats per flight over the past year. To accomplish this, the records of 225 flights are randomly selected and the number of unoccupied seats is noted for each of the sampled flights. The sample mean is 11.6 seats and the sample standard deviation is 4.2 seats. Construct a 95% confidence interval.<\/strong><\/p>

<\/p>

3. A professor wants to know if her introductory statistics class has a good grasp of basic math. Eight students are chosen at random from the class and given a math proficiency test. The professor wants the class to be able to score above 70 on the test. The sample mean score of the six students is 79 with a sample standard deviation of 12.931. Can the professor have 95% confidence that the mean score for the class on the test would be above 70? Formulate the hypothesis, compute the test statistic, find the critical value, and draw a conclusion.<\/strong><\/p>

<\/p>

4. Suppose a consumer group suspects that the proportion of households that have three cell phones is 30%. A cell phone company has reason to believe that the proportion is not 30%. Before they start a big advertising campaign, they conduct a hypothesis test. Their marketing people survey 150 households with the result that 46 of the households have three cell phones. For the hypothesis test, use a 5% level of significance. Formulate the hypothesis, compute the test statistic, find the critical value, and draw a conclusion.<\/strong><\/p>

<\/p>

5. The administration at a college wishes to estimate, the proportion of all its entering freshmen who graduate within four years, with 95% confidence. Estimate the minimum size sample required. Assume that the population standard deviation is = 0.25 and precision level is 0.03.<\/strong><\/p>

<\/p>

6. Using the student grades data below, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the regression model? If a student scores 75 on the midterm, what would you predict their grade on the final exam to be?<\/strong><\/p>

<\/p>

7. Forecast the IBM stock prices shown below using a two-period moving average. Compute MAD, MSE, and MAPE.<\/strong><\/p>

<\/p>

8. Forecast the DJ Industrials Index data shown below using simple exponential smoothing with a smoothing constant of 0.4.<\/strong><\/p>", "transcribed_text": "", "related_book": { "title": "South-Western Federal Taxation 2020 Comprehensive", "isbn": "357109147, 978-0357109144", "edition": "43rd Edition", "authors": "David M. Maloney, William A. Raabe, James C. Young, Annette Nellen, William H. Hoffman", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/1962.jpg", "uri": "\/textbooks\/south-western-federal-taxation-2020-comprehensive-43rd-edition-9780357109144", "see_more_uri": "" }, "free_related_book": { "isbn": "B005FXEZYE", "uri": "\/textbooks\/constitutions-of-value-law-governance-and-political-ecology-1st-edition-b0brnvkjdb-252283", "name": "Constitutions Of Value Law Governance And Political Ecology", "edition": "1st Edition" }, "question_posted": "2024-06-28 03:12:23", "see_more_questions_link": "\/study-help\/questions\/sciences-statistics-2024-March-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/define-each-of-the-following-terms-a-design-alternatives-b", "description": "Define each of the following terms. a. Design alternatives b. Forms analysis sheet c. File- related matrices d. Operational feasibility", "stars": 3 }, { "url": "\/study-help\/psychology\/how-would-you-handle-the-difficulty-level-of-the-texts-1984653", "description": "How would you handle the difficulty level of the texts?", "stars": 3 }, { "url": "\/glen-and-diane-flood-owned-and-operated-floods-auto-parts", "description": "Glen and Diane Flood owned and operated Floods Auto Parts and Glenwood Wrecker Service in Chatsworth, Georgia. The companies offerings to the local market included the sale of wholesale and retail...", "stars": 3 }, { "url": "\/study-help\/questions\/you-are-to-design-a-heat-exchanger-to-heat-the-9836095", "description": "You are to design a heat exchanger to heat the water for a large athletic center. The exchanger must be able to heat water with flowrates up to 1 2 0 g p m from 5 0 F to 1 4 0 F . The exchanger will...", "stars": 3 }, { "url": "\/study-help\/questions\/one-of-your-ancestors-made-sure-you-would-live-a-705278", "description": "One of your ancestors made sure you would live a good life. He invested AED 10000 at 5% interest in a fund for your 100 years ago. (a) How much would the investment be worth today? Clearly show your...", "stars": 3 }, { "url": "\/study-help\/questions\/thinking-about-your-natural-negotiation-style-ask-yourself-in-general-1000047", "description": "Thinking about your natural negotiation style, ask yourself: In general, when does your style help you and when does it not help you in negotiation situations? Now, think about how you can translate...", "stars": 3 }, { "url": "\/study-help\/questions\/there-are-three-3-columns-the-first-column-is-the-1000024", "description": "There are three (3) columns, the first column is the reduction of prevention costs, second column is progressive reduction of appraisal costs, and the last column is reduction of failure costs. 2.In...", "stars": 3 }, { "url": "\/study-help\/questions\/scenario-1-4-1-after-it-launched-1003554", "description": "( Scenario 1 4 - 1 ) After it launched, PlayWithMe contracted with three major search engines to show its advertisements any time a user searched for certain terms that were closely identified with...", "stars": 3 }, { "url": "\/study-help\/questions\/there-are-three-different-methods-commonly-used-for-capturing-network-1004560", "description": "There are three different methods commonly used for capturing network data. These are (1) using a network tap, (2) using a SPAN port on a switch, and (3) using a tool built into a network device...", "stars": 3 }, { "url": "\/study-help\/questions\/gross-amount-of-invouce-is-8-5-0-1001995", "description": "Gross amount of invouce is $ 8 5 0 . there is no freight charge. date of invoice is 8 \/ 4 . terms of invoice are 3 \/ 1 0 , 2 \/ 1 5 and n \/ 3 0 . date of payment is 8 \/ 1 8 . find the cash discount....", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/a-teacher-claimed-that-students-are-getting-higher-gpa-in-4228665", "next": "\/study-help\/questions\/first-introduce-yourself-to-the-class-include-your-major-and-4228667" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Sciences", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/sciences" }, { "name": "Mathematics", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/sciences-mathematics" }, { "name": "***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL FORMULAS FOR EACH PROBLEM - ATTACHED", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/please-provide-a-stepbystep-of-excel-formulas-for-each-problem-4228666" } ], "skill_details": { "skill_id": "342", "skill_name": "Mathematics", "parent_id": "5" } }" } }