Answer Happy

Would like help with these problems using excel.
Lab #2.pdf Page 1 of 3 Q Search © Markup View Zoom Share Highlight Rotate Search Lab #2 Stat 2438 . These problems should be donc using Microsoft Excel • Make sure that tables are not split onto two pages and that you can read the entire label. Points will be taken off for editing, spelling and general appearance of the lab. • Turn in a pdf on Canvas These problems must be dume using Microsoft Excel then cupied to a Word document. Example Problem A rental agency claims that the average rent fixe a two-bestroom apartment in Portland, OR is less than $750. Assume that apartment rents are normally distributed. A random sample of's two-bedroxım apartment rents were found to be: 5700 5799 $725 5800 5715, To test the rental agencies claim when -0.05 we net up the following hypotheses: 1,750 H: 1750 The claim this time is in the alternative hypothesis. To do this problem using Excel, cuter the data into column A and the same number of zeros in columnn 13. I have come the example in the spreadsheet below, you will need to change the numbers to fit your problem. Choose the drop down menu Tools, and click on Data Analysis. Data Analysis Ayer Tande Hestar Moving Average Cancel Random Number Generation Rank and Percentile Regression Sarging Pared Torge for Men t-Test: Two-Sample Assning Equal variances L-Test: Two Sarple Awg requal variances 2-Test: Two Sample for Mars Choose the wyptian t-Test: Puired Two Sample for Meanx. Click OK, A dialogue box will swip up. t Test: Paired I wo Sample for Means rout Variable Range SA$1:54 Wale Range Hypothund Monference Cancel Alpha 0.05 Output optar Otto Now by Newark Click into the box next to Variable 1, then take your mouse and highlight all of the data in column A. For this example the box now has a SA$1:$A$S, which means the data is in oell Al to AS. Then click a into the box next to Variable 2, take your mouse and highlight the Zeus in culun 13. For this example

Lab #2.pdf Page 2 of 3 Q Search View Zoom Share Highlight Rotate Markup Search the box now has a SBS1:5B35, which means the data is in cell BI to BS. Click into the box next to Hypothesized Mean Difference, and enter the hypothesized mean, for this example 750. Make sure that alpha is set to the same level of significance for your problem, in this cxample it was 0.05. Then click on OK and you should get a similar table to the one below. I have highlighted the test statistic 0.1024 and the appropriate p-valuc 0.4617, notice that it gives you both the one-tailed and two-tailed results, E Variable 2 2 0 0 5 AB t-Test: Paired Two Sample for 1 700 0 Means 2 799 0 Mcan 3 800 0 Variance 4 4 725 0 Observations 5 0 Pearson Correlation 6 Hypothesized Meau Difference 7 Stal R P(Tt) metail 9 Critical one-tail 10 PTC-t) wc-tail 11 Critical two-tail etc. D Variable 1 747.8 2306.7 5 #DIV/0! 750 -0.102426 0.4616738 2.1318465 19.9233476 715 2.7764509 Since the p-value is greater than alpha, we do not reject H. In conclusion, there is not enough evidence to conclude that the average rent in Portland, Oregon is less than $750. Arrange the problems in the order in which they are assigned. All the data is saved in the Excel document Stat243_Lab2_data.xls _ The Pelican Data is copied in this file as well in sheet 2 1. In a Word document Your name in the upper leſ comer and Sla1243 B right below your name()(point) Do the following problems in Microsoft Excel using the process described nbove. Your lab does not need to include the raw clata, just the table. Copy each table to the Word document and highlight the appropriate p-value. Under each table type the hypotheses, decision and summary, using the results from Excel, again you should not be doing the calculations by hand! 2. A random sample of 16 students selected from the student body of a large university was selected. We want to determine if the average age of all the students at the university is significantly different from 24. Assume the distribution of the populativa olages is nisl. Let u -0.05. (10 points) 3. A carpet company advertises that it will deliver your carpet within 14 days of purchase. A random sample ol 20 pase customers is laken. We wan. to determine if the average burber of days fur carpa delivery is within 14 days. I. -0.01. (10 points) 4. A mundom sample of 40 cookies is taken to test the claim that on avenge each cookie contains at least 9 chocolate chips. Let - 0.10 (10 points)

DLab #2.pdf View Page 3 of 3 Q Search Zoom Share Highlight Rotate Markup Search 5. Use the data from Pelican data to answer the following question. (10 points) The manager knows from previous years that the company will provide an annual bonus if the average sales per customer is greater than $30.01. Based on this sample - with a 5% level of confidence-should they expect an annual bonus? 6. Save your word document as a pdf and submit to canvas. Check organization, make sure all the required steps are complete and conclusions are clearly written. Alsacheck spell anul organization (7 points)

Lab 1 data Problem 2 Problem 3 Problem 4 Problem 5 Age Days Chocolate Chips See Sheet 2 25 13 6 18 20 8 25 15 10 19 10 9 31 15 8.5 23 14 7 21 17 9 19 13 10 22 18 8 23 14 9 26 16 10 24 18 6 25 15 11 11 7 15 8 10 9 11 8 15 10 16 7 14 6 8 9 11 10.5 9 8 6 7 8 9 O o O ON

Age 32 36 32 28 34 44 30 40 46 36 48 Method Custom of Marital er Payment Items Discount Sales Gender Status 1 Discover 1 0.00 39,50 Male Married 2 Proprietar 1 25.60 102.40 Female Married 3 3 Proprietar 1 0.00 22.50 Female Married 4 Proprietar 5 121.10 100.40 Female Married 5 Mastercar 2 0.00 54.00 Female Married 6 6 Mastercar 1 0.00 44.50 Female Married 7 Proprietar 2 19.50 78.00 Female Married 8 Visa 1 0.00 22.50 Female Married 9 9 Proprietar 2 22.48 56.52 Female Married 10 Proprietar 1 0.00 44.50 Female Married 11 Proprietar 1 0.00 29.50 Female Married 12 Proprietar 1 7.90 31.60 Female Married 13 Visa 9 103.60 160.40 Female Married 14 Visa 2 24.50 64.50 Female Married 15 Visa 1 0.00 49.50 Male Single 16 Proprietar 2 12.60 71.40 Male Single 17 Proprietar 3 53.00 94.00 Female Single 18 Discover 3 0.00 54.50 Female Married 19 Mastercar 2 19.00 38.50 Female Married 20 Proprietar 6 32.20 44.80 Female Married 21 Proprietar 1 7.90 31.60 Female Single 22 Proprietar 4 29.67 70.82 Female Married 23 American 7 66.50 266.00 Female Married 24 Proprietar 2 0.00 74.00 Female Married 25 Visa 2 14.50 39.50 Male Married 26 Proprietar 1 9.48 30.02 Female Married 27 Proprietar 1 0.00 44.50 Female Married 28 Proprietar s 48.20 192.80 Female Single 29 Proprietar 3 37.30 71.20 Female Married 30 Proprietar 1 4.50 18.00 Female Married 31 Mastercar 2 15.80 63.20 Female Married 32 Proprietar 1 0.00 75.00 Female Married 33 Proprietar 3 15.80 63.20 Female Married 34 Proprietar 1 0.00 40.00 Female Married 35 Mastercan 5 10.00 105.50 Female Married 36 Mastercar 1 0.00 29.50 Male Single 37 Visa 2 0.00 102.50 Female Single 38 Proprietar 6 14.50 117.50 Female Married 39 Proprietar 5 S 25.02 13.23 Female Married 40 Proprietar 2 0.00 52.50 Female Married 41 Proprietar 13 62.70 198.80 Female Married 42 Visa 4 16.50 19.50 Female Married 43 Proprietar 2 0.00 123.50 Female Married 44 Proprietar 1 15.60 62.40 Female Married 45 Proprietar 2 35.20 23.80 Female Married 46 Proprietar 2 19.40 39.60 Female Married 47 Mastercar 1 0.00 25.00 Female Married 48 Proprietar 3 20.11 63.64 Female Married 49 Proprietar 1 4.68 14.82 Female Married SO Mastercar 9 94.30 145.20 Female Married 51 Proprietar 6 58.88 176.62 Female Married 52 Proprietar 5 51.70 118.80 Male Married 53 Discover 1 0.00 58.00 Female Single 54 Visa 2 0.00 74.00 Female Single 55 Mastercar 2 2 0.00 49.50 Female Married 56 Proprietar 3 35.40 141.60 Female Married 57 Proprietar 6 6 56.40 123.10 Female Married 58 Proprietar 2 2 20.10 80.40 Female Married 59 Mastercan 4 4 28.30 65.20 Female Married 60 Proprietar 4 19.50 113.00 Female Single 61 Proprietar 1 19.20 108.80 Female Married 62 Proprietar 3 91.48 59.91 Female Single 63 Proprietar 5 37.40 53.60 Female Married 64 Proprietar 1 7.90 31.60 Female Single 65 Proprietar 2 9.50 49.50 Female Married 66 Proprietar 1 9.90 39.60 Female Married 67 Proprietar 2 29.50 59.50 Female Married 68 Proprietar 5 36.70 146.80 Femald Married 69 Proprietar 2 11.80 47.20 Male Married 70 Proprietar 8 18.95 95.05 Female Married 71 Proprietar 5 57.18 155.32 Female Married 72 Mastercar 4 10.00 58.00 Female Married 73 Proprietar 1 0.00 69.00 Female Single 74 Proprietar 2 15.50 46.50 Female Married 75 Proprietar 2 14.28 45.22 Female Married 76 Proprietar 46.26 84.74 Female Married 77 Proprietar 2 0.00 39.00 Female Married 78 Proprietar 4 35.11 111.14 Female Married 79 Proprietar 3 31.20 86,80 Female Married 80 Discover 2 0.00 89.00 Female Married 81 Mastercan 2 19.50 78.00 Female Married 82 Proprietar 6 29.31 53.20 Female Single 83 Visa 4 14.50 58.50 Female Married 84 Proprietar 3 19.50 46.00 Female Married 85 Visa 2 0.00 37.50 Female Married 86 Proprietar 1 5.20 20.80 Female Married 87 Mastercar 6 0.00 144.00 Female Single 88 Proprietar 4 0.00 107.00 Female Married 89 Proprietar 1 1 7.90 31.60 Female Single 90 Proprietar 6 46.40 57.60 Female Married 91 Proprietar 4 158,30 95.20 Female Married 92 Proprietar 1 7.08 22.42 Female Married 93 Proprietar 5 0.00 159.75 Female Married 94 Proprietar 17 33.00 229.50 Female Married 95 American 3 0.00 66.00 Female Married 96 Mastercar 1 0.00 39.50 Female Married 97 Proprietar 9 82.75 253.00 Female Married 98 Proprietar 10 18.00 287.59 Female Married 99 Proprietar 2 31.40 47.60 Female Married 100 Proprietar 1 11.06 28.44 Female Married 40 40 46 24 36 22 40 32 56 28 38 so 42 48 60 54 42 32 70 28 52 44 34 56 36 42 so 44 58 42 46 48 54 38 60 46 30 32 46 38 68 78 20 32 38 54 48 46 50 46 30 54 42 48 62 34 28 46 54 30 32 22 32 74 62 42 28 38 54 68 30 36 44 44 62 48 36 20 42 54 54 72 30 46 44 30 52 30 44