Hi, can you please help me answer the following questions correctly. When develo

Question

Hi, can you please help me answer the following questions correctly. When developing the histogram and scatter plot could you please also include the workings, for example, the Class, Frequency, BIN values, etc in a table format. Can you please ensure that the histogram bars are touching each other and you have vertical lines to define each bar on the histogram. Also, below you will find the data set require to answer this question, the data is from an EXCEL sheet. Thanks for your help.

A researcher wishes to use the graphical descriptive methods to present the data.

(a)      The number of observations (N) is 400 families. Calculate the number of classes (K) the researcher should use to construct a histogram for each variable.

(b)      He suggests using class intervals such as 0-6, 6-12, 12-18, ... for the TV hours and class intervals 0-30000, 30000-60000, 60000-90000, .... , for the Debt variable. Use appropriate BIN values from these class intervals to draw a histogram for each variable and comment on the shape of the two distributions.

(c)       Draw a scatter plot to investigate whether there is a linear relationship between Debt and TV hours. Briefly explain the selection of each variable on the X and Y axes and why? On the same plot, fit a linear trend line including the equation and the coefficient of determination R2.

Note: It is important that the histogram bars are touching each other and you have vertical lines to define each bar on the histogram.

TV Hours Debt ($) 40 81708 15 140400 36 228366 37 137176 42 99522 27 164431 25 108764 26 169169 22 36617 17 111109 19 94674 20 129337 23 26613 43 128545 43 158004 26 56879 25 100078 36 158097 18 107671 35 198811 30 97956 17 72762 13 67721 44 195427 26 181866 24 98324 24 115842 30 20516 32 169104 16 97961 29 145794 22 140254 30 71460 22 113584 40 141652 24 117790 30 184908 34 137167 29 108140 9 96550 25 140823 32 129735 23 132452 37 119666 34 79125 45 212328 44 108628 29 74366 31 38210 25 43051 30 105135 40 134104 28 142997 26 109414 41 86637 38 184874 28 134691 33 139894 33 198234 42 145258 34 158861 35 102670 23 146193 42 189789 21 139918 29 77816 29 87156 42 143401 35 152845 18 63710 28 144395 43 122953 49 112753 30 144107 22 159829 15 87473 16 98110 13 132269 37 188238 31 156232 25 168223 26 83595 21 118695 42 145268 35 95132 25 157737 24 134285 26 100434 52 160023 36 149815 23 148030 42 131469 13 82784 28 138214 23 43717 40 142449 11 96618 23 99874 16 80686 28 87820 28 108176 57 204399 43 237131 30 107644 17 102938 30 113858 34 166206 34 94335 20 65109 29 81096 20 113611 21 70398 44 172270 16 79625 53 277234 14 25240 24 136486 27 73805 24 69627 35 111226 35 147720 36 121768 41 245525 44 210765 14 121672 32 135904 44 89620 40 130725 11 121759 20 20938 38 130424 36 177563 33 122979 37 167132 50 127318 22 126937 31 148643 26 76042 28 120813 17 129270 16 123674 27 109214 20 38750 27 85623 31 151718 40 157464 31 111780 30 163191 34 124768 21 141458 18 26787 24 112242 32 170331 20 69537 25 130697 41 182681 6 55733 37 179771 25 91238 24 34773 23 132615 24 118057 34 124292 24 143841 42 105462 50 202901 29 68789 20 105138 35 155192 32 142751 41 111248 21 67076 41 107247 36 180712 17 114471 29 97739 26 97754 47 224816 26 223353 36 175944 44 203962 13 92146 41 101175 30 187300 39 192007 24 37598 22 88004 36 108941 28 110546 32 193663 25 144668 22 130141 28 98623 21 97394 46 195783 31 151455 31 85199 41 212616 13 170678 15 117352 30 129755 21 125788 34 118035 15 107869 33 134457 35 147339 48 183981 32 112775 39 88501 26 77897 43 100014 25 121865 42 224147 28 135283 16 73417 27 60876 21 74202 30 112627 20 145242 29 128341 21 82488 48 154691 20 93811 35 112924 47 161235 15 91041 26 108496 35 98519 31 122107 11 37079 33 149411 19 49485 28 145584 41 134094 32 101917 42 97906 49 153212 37 134969 30 128753 11 92867 37 177611 29 67417 19 59563 40 144899 18 81715 36 203050 51 219649 27 76156 38 137654 39 159615 22 85963 33 139426 43 112707 25 91388 28 60683 29 115705 34 97118 27 133000 53 197239 38 163969 32 144890 57 222989 21 73094 42 124396 32 70397 35 89541 21 86759 10 99232 48 168076 33 164474 23 176994 10 141586 34 113240 28 74343 37 103571 37 91404 26 154167 21 82688 30 153660 39 110530 42 111792 29 121059 38 100426 39 129551 18 94711 35 98410 40 138475 21 123646 38 168140 18 145342 31 184485 37 192462 41 174199 34 145248 10 43180 40 133502 22 170907 39 147070 32 149343 42 169901 41 174281 29 173297 17 64638 24 130033 38 167605 27 73241 16 85779 27 85036 30 130868 25 58187 25 146589 25 85713 33 178693 26 146013 49 165009 24 143757 51 179427 20 27125 47 147454 34 87137 45 223891 35 181495 44 184006 28 166470 32 130471 9 123851 14 96700 42 148868 17 78844 46 218211 44 224258 40 166006 44 127346 40 166304 20 104699 40 60972 28 75211 36 75893 37 203585 28 135597 38 201228 40 161317 38 147482 42 178140 28 140582 32 128270 12 23779 39 207713 23 76834 30 58128 15 127139 16 176062 15 99262 31 83186 35 159564 22 85684 30 95657 26 148101 33 119430 38 156119 27 73534 38 129387 31 142914 46 170768 25 89839 38 136993 25 112960 32 135987 31 139847 27 130218 33 176889 33 128106 22 116861 36 102817 46 93077 49 168868 33 117487 40 149172 18 73860 24 149120 22 152044 12 79055 14 56313 48 214847 45 198605 42 148376 19 107299 35 138035 31 121148 38 223955 29 126861 29 121159 38 213463 51 197297 29 29408 36 140720 37 174778 32 114879 30 107101 32 141742

Explanation / Answer

a) to find number of class (k)

k = 1+ 3.322 * log (N)

k = 1+ 3.322 *log (400)

k= 9.64

nearly k= 10

part b and c answer is ready but due to site problem emage not uploaded

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.