Please Complete the Problem Set. Statistics Expert Required. 10 Hours

profilejhayes
CardioGoodFitnessbyproduct.xlsx
Home>Mathematics homework help>Statistics homework help>Please Complete the Problem Set. Statistics Expert Required. 10 Hours

Sheet4

Count of Gender Column Labels
Row Labels Female Male (blank) Grand Total Frequency Count Contigency Table (Gender/Years of Edu) Conditional Probabiliites Contigency Table (Gender/Years of Edu)
1 1 1 Years of Education Female Male Marginal Years of Education Female Male
2 10 4 14 12 2 2 12 0 1
3 26 28 54 13 3 3 13 0 1
4 3 6 9 14 18 12 30 14 0.6 0.4
5 1 1 2 15 2 2 4 15 0.5 0.5
(blank) 16 19 20 39 16 0.4871794872 0.5128205128
Grand Total 40 40 80 18 1 1 2 18 0.5 0.5
Marginal 40 40 80 Marginal 0.5 0.5
Joint/Marginal ProbabilitiesContigency Table (Gender/Years of Edu) Conditional Probabiliites Contigency Table (Gender/Marital Status)
Gender/Education Years of Education Female Male Marginal Marital Status Female Male Marginal Marital Status Female Male
Gender/Marital Status 12 0 0.025 0.025 Partnered 27 21 48 Partnered 0.5625 0.4375
Gender/SelfFitness Reporting 13 0 0.0375 0.0375 Single 13 19 32 Single 0.40625 0.59375
Education/Marital Status 14 0.225 0.15 0.375 Marginal 40 40 80 Marginal 0.5 0.5
Education/SelfFitness Reporting 15 0.025 0.025 0.05
Marital Status/SelfFitness Reporting 16 0.2375 0.25 0.4875 Joint/Marginal ProbabilitiesContigency Table (Gender/Marital Status)
18 0.0125 0.0125 0.025 Marital Status Female Male Marginal
Marginal 0.5 0.5 1 Partnered 0.3375 0.2625 0.6
Single 0.1625 0.2375 0.4
Marginal 0.5 0.5 1
Joint Probabilities
Marginal Probabilities
Conditional Probabilities
Marital Status Female Male Marginal Self-Rated Fitness Pr(F| self rate) Pr (M | Self Rate)
1 1 1 1 0 1
2 10 4 14 2 0.7142857143 0.2857142857
3 26 28 54 3 0.4814814815 0.5185185185
4 3 6 9 4 0.3333333333 0.6666666667
5 1 1 2 5 0.5 0.5
Marginal 40 40 80
Self-Rated Fitness Female Male Marginal Self-Rated Fitness Pr(self rate| F) Pr(self rate| M)
1 0 0.0125 0.0125 1 0 0.025
2 0.125 0.05 0.175 2 0.25 0.1
3 0.325 0.35 0.675 3 0.65 0.7
4 0.0375 0.075 0.1125 4 0.075 0.15
5 0.0125 0.0125 0.025 5 0.025 0.025
Marginal 0.5 0.5 1

TM195

Product Age Gender Years of Education Marital Status Planned Usage Self Rated Fitness Income Expected Miles
TM195 18 Male 14 Single 3 4 29562 112
TM195 19 Male 15 Single 2 3 31836 75
TM195 19 Female 14 Partnered 4 3 30699 66
TM195 19 Male 12 Single 3 3 32973 85
TM195 20 Male 13 Partnered 4 2 35247 47
TM195 20 Female 14 Partnered 3 3 32973 66
TM195 21 Female 14 Partnered 3 3 35247 75
TM195 21 Male 13 Single 3 3 32973 85
TM195 21 Male 15 Single 5 4 35247 141
TM195 21 Female 15 Partnered 2 3 37521 85
TM195 22 Male 14 Single 3 3 36384 85
TM195 22 Female 14 Partnered 3 2 35247 66
TM195 22 Female 16 Single 4 3 36384 75
TM195 22 Female 14 Single 3 3 35247 75
TM195 23 Male 16 Partnered 3 1 38658 47
TM195 23 Male 16 Partnered 3 3 40932 75
TM195 23 Female 14 Single 2 3 34110 103
TM195 23 Male 16 Partnered 4 3 39795 94
TM195 23 Female 16 Single 4 3 38658 113
TM195 23 Female 15 Partnered 2 2 34110 38
TM195 23 Male 14 Single 4 3 38658 113
TM195 23 Male 16 Single 4 3 40932 94
TM195 24 Female 16 Single 4 3 42069 94
TM195 24 Female 16 Partnered 5 5 44343 188
TM195 24 Male 14 Single 2 3 45480 113
TM195 24 Male 13 Partnered 3 2 42069 47
TM195 24 Female 16 Single 4 3 46617 75
TM195 25 Female 14 Partnered 3 3 48891 75
TM195 25 Male 14 Partnered 2 3 45480 56
TM195 25 Female 14 Partnered 2 2 53439 47
TM195 25 Female 14 Partnered 3 3 39795 85
TM195 25 Male 16 Single 3 4 40932 113
TM195 25 Female 16 Partnered 2 2 40932 47
TM195 25 Male 16 Single 3 3 43206 85
TM195 26 Female 14 Partnered 3 4 44343 113
TM195 26 Female 16 Partnered 4 3 52302 113
TM195 26 Male 16 Partnered 2 2 53439 47
TM195 26 Male 16 Partnered 3 3 51165 85
TM195 26 Female 16 Single 3 3 36384 66
TM195 26 Male 16 Partnered 4 4 44343 132
TM195 26 Male 16 Single 3 3 50028 85
TM195 27 Female 14 Partnered 3 2 45480 66
TM195 27 Male 16 Single 4 3 54576 85
TM195 27 Female 14 Partnered 2 3 45480 56
TM195 28 Female 14 Partnered 2 3 46617 56
TM195 28 Female 16 Partnered 2 3 52302 66
TM195 28 Male 14 Single 3 3 52302 103
TM195 28 Female 14 Partnered 3 3 54576 94
TM195 28 Male 14 Single 4 3 54576 113
TM195 28 Female 16 Partnered 3 3 51165 56
TM195 29 Male 18 Partnered 3 3 68220 85
TM195 29 Female 14 Partnered 2 2 46617 38
TM195 29 Female 16 Partnered 4 3 50028 94
TM195 30 Male 14 Partnered 4 4 46617 141
TM195 30 Male 14 Single 3 3 54576 85
TM195 31 Male 14 Partnered 2 2 54576 47
TM195 31 Female 14 Single 2 2 45480 47
TM195 32 Female 14 Single 3 4 46617 113
TM195 32 Male 14 Partnered 4 3 52302 85
TM195 33 Female 16 Single 2 2 55713 38
TM195 33 Female 16 Partnered 3 3 46617 85
TM195 34 Male 16 Single 4 5 51165 169
TM195 34 Female 16 Single 2 2 52302 66
TM195 35 Male 16 Partnered 4 3 48891 85
TM195 35 Female 16 Partnered 3 3 60261 94
TM195 35 Female 18 Single 3 3 67083 85
TM195 36 Male 12 Single 4 3 44343 94
TM195 37 Female 16 Partnered 3 3 37521 85
TM195 38 Male 16 Partnered 3 3 46617 75
TM195 38 Female 14 Partnered 2 3 54576 56
TM195 38 Male 14 Single 2 3 52302 56
TM195 38 Male 16 Partnered 3 3 56850 75
TM195 39 Male 16 Partnered 4 4 59124 132
TM195 40 Male 16 Partnered 3 3 61398 66
TM195 41 Male 16 Partnered 4 3 54576 103
TM195 43 Male 16 Partnered 3 3 53439 66
TM195 44 Female 16 Single 3 4 57987 75
TM195 46 Female 16 Partnered 3 2 60261 47
TM195 47 Male 16 Partnered 4 3 56850 94
TM195 50 Female 16 Partnered 3 3 64809 66

TM498

Product Age Gender Years of Education Marital Status Planned Usage Self Rated Fitness Income Expected Miles
TM498 19 Male 14 Single 3 3 31836 64
TM498 20 Male 14 Single 2 3 32973 53
TM498 20 Female 14 Partnered 3 3 34110 106
TM498 20 Male 14 Single 3 3 38658 95
TM498 21 Female 14 Partnered 5 4 34110 212
TM498 21 Male 16 Partnered 2 2 34110 42
TM498 21 Male 12 Partnered 2 2 32973 53
TM498 23 Male 14 Partnered 3 3 36384 95
TM498 23 Male 14 Partnered 3 3 38658 85
TM498 23 Female 16 Single 3 3 45480 95
TM498 23 Male 16 Partnered 4 3 45480 127
TM498 23 Female 16 Partnered 3 2 43206 74
TM498 23 Female 14 Single 3 2 40932 53
TM498 23 Male 16 Partnered 3 3 45480 64
TM498 24 Female 14 Single 3 2 40932 85
TM498 24 Male 14 Single 3 4 48891 106
TM498 24 Female 16 Single 3 3 50028 106
TM498 25 Female 14 Partnered 2 3 45480 85
TM498 25 Female 14 Single 3 4 43206 127
TM498 25 Male 16 Partnered 2 2 52302 42
TM498 25 Female 14 Partnered 5 3 47754 106
TM498 25 Male 14 Single 3 3 45480 95
TM498 25 Female 14 Single 2 3 43206 64
TM498 25 Male 14 Partnered 4 3 45480 170
TM498 25 Male 14 Partnered 3 4 43206 106
TM498 25 Male 16 Partnered 2 3 50028 53
TM498 25 Female 14 Single 2 2 45480 42
TM498 25 Male 14 Single 4 3 48891 127
TM498 26 Female 16 Partnered 4 3 45480 85
TM498 26 Female 16 Single 4 4 50028 127
TM498 26 Male 16 Single 4 3 51165 106
TM498 27 Male 14 Single 4 2 45480 53
TM498 29 Female 14 Partnered 3 3 51165 95
TM498 30 Female 14 Single 3 3 57987 74
TM498 30 Female 13 Single 4 3 46617 106
TM498 31 Male 16 Partnered 3 3 52302 95
TM498 31 Female 16 Partnered 2 3 51165 64
TM498 31 Female 18 Single 2 1 65220 21
TM498 32 Male 16 Single 4 3 60261 127
TM498 32 Male 16 Partnered 3 3 53439 95
TM498 33 Male 13 Partnered 4 4 53439 170
TM498 33 Female 16 Partnered 2 3 50028 85
TM498 33 Male 16 Partnered 3 3 51165 95
TM498 33 Female 16 Partnered 5 3 53439 95
TM498 33 Female 18 Single 3 4 47754 74
TM498 34 Female 16 Partnered 4 3 64809 95
TM498 34 Male 16 Partnered 3 4 59124 85
TM498 34 Male 15 Single 3 3 67083 85
TM498 35 Female 14 Partnered 3 2 52302 53
TM498 35 Male 16 Partnered 3 2 53439 53
TM498 35 Female 16 Single 3 2 50028 64
TM498 35 Male 16 Partnered 3 3 53439 95
TM498 37 Female 16 Partnered 2 3 48891 85
TM498 38 Female 16 Partnered 4 3 62535 85
TM498 38 Male 16 Partnered 3 3 59124 106
TM498 40 Female 16 Partnered 3 3 61398 85
TM498 40 Female 16 Single 3 3 57987 85
TM498 40 Male 16 Partnered 3 3 64809 95
TM498 45 Male 16 Partnered 2 2 54576 42
TM498 48 Male 16 Partnered 2 3 57987 64

TM798

Product Age Gender Years of Education Marital Status Planned Usage Self Rated Fitness Income Expected Miles
TM798 22 Male 14 Single 4 3 48658 106
TM798 22 Male 16 Single 3 5 54781 120
TM798 22 Male 18 Single 4 5 48556 200
TM798 23 Male 16 Single 4 5 58516 140
TM798 23 Female 18 Single 5 4 53536 100
TM798 23 Male 16 Single 4 5 48556 100
TM798 24 Male 16 Single 4 5 61006 100
TM798 24 Male 18 Partnered 4 5 57271 80
TM798 24 Female 16 Single 5 5 52291 200
TM798 24 Male 16 Single 5 5 49801 160
TM798 25 Male 16 Partnered 4 5 49801 120
TM798 25 Male 16 Partnered 4 4 62251 160
TM798 25 Female 18 Partnered 5 5 61006 200
TM798 25 Male 18 Partnered 4 3 64741 100
TM798 25 Male 18 Partnered 6 4 70966 180
TM798 25 Male 18 Partnered 6 5 75946 240
TM798 25 Male 20 Partnered 4 5 74701 170
TM798 26 Female 21 Single 4 3 69721 100
TM798 26 Male 16 Partnered 5 4 64741 180
TM798 27 Male 16 Partnered 4 5 83416 160
TM798 27 Male 18 Single 4 3 88396 100
TM798 27 Male 21 Partnered 4 4 90886 100
TM798 28 Female 18 Partnered 6 5 92131 180
TM798 28 Male 18 Partnered 7 5 77191 180
TM798 28 Male 18 Single 6 5 88396 150
TM798 29 Male 18 Single 5 5 52290 180
TM798 29 Male 14 Partnered 7 5 85906 300
TM798 30 Female 16 Partnered 6 5 90886 280
TM798 30 Male 18 Partnered 5 4 103336 160
TM798 30 Male 18 Partnered 5 5 99601 150
TM798 31 Male 16 Partnered 6 5 89641 260
TM798 33 Female 18 Partnered 4 5 95866 200
TM798 34 Male 16 Single 5 5 92131 150
TM798 35 Male 16 Partnered 4 5 92131 360
TM798 38 Male 18 Partnered 5 5 104581 150
TM798 40 Male 21 Single 6 5 83416 200
TM798 42 Male 18 Single 5 4 89641 200
TM798 45 Male 16 Single 5 5 90886 160
TM798 47 Male 18 Partnered 4 5 104581 120
TM798 48 Male 18 Partnered 4 5 95508 180

CardioGoodFitnesstxt

Product Age Gender Years of Education Marital Status Planned Usage Self Rated Fitness Income Expected Miles
TM195 18 Male 14 Single 3 4 29562 112
TM195 19 Male 15 Single 2 3 31836 75
TM195 19 Female 14 Partnered 4 3 30699 66
TM195 19 Male 12 Single 3 3 32973 85
TM195 20 Male 13 Partnered 4 2 35247 47
TM195 20 Female 14 Partnered 3 3 32973 66
TM195 21 Female 14 Partnered 3 3 35247 75
TM195 21 Male 13 Single 3 3 32973 85
TM195 21 Male 15 Single 5 4 35247 141
TM195 21 Female 15 Partnered 2 3 37521 85
TM195 22 Male 14 Single 3 3 36384 85
TM195 22 Female 14 Partnered 3 2 35247 66
TM195 22 Female 16 Single 4 3 36384 75
TM195 22 Female 14 Single 3 3 35247 75
TM195 23 Male 16 Partnered 3 1 38658 47
TM195 23 Male 16 Partnered 3 3 40932 75
TM195 23 Female 14 Single 2 3 34110 103
TM195 23 Male 16 Partnered 4 3 39795 94
TM195 23 Female 16 Single 4 3 38658 113
TM195 23 Female 15 Partnered 2 2 34110 38
TM195 23 Male 14 Single 4 3 38658 113
TM195 23 Male 16 Single 4 3 40932 94
TM195 24 Female 16 Single 4 3 42069 94
TM195 24 Female 16 Partnered 5 5 44343 188
TM195 24 Male 14 Single 2 3 45480 113
TM195 24 Male 13 Partnered 3 2 42069 47
TM195 24 Female 16 Single 4 3 46617 75
TM195 25 Female 14 Partnered 3 3 48891 75
TM195 25 Male 14 Partnered 2 3 45480 56
TM195 25 Female 14 Partnered 2 2 53439 47
TM195 25 Female 14 Partnered 3 3 39795 85
TM195 25 Male 16 Single 3 4 40932 113
TM195 25 Female 16 Partnered 2 2 40932 47
TM195 25 Male 16 Single 3 3 43206 85
TM195 26 Female 14 Partnered 3 4 44343 113
TM195 26 Female 16 Partnered 4 3 52302 113
TM195 26 Male 16 Partnered 2 2 53439 47
TM195 26 Male 16 Partnered 3 3 51165 85
TM195 26 Female 16 Single 3 3 36384 66
TM195 26 Male 16 Partnered 4 4 44343 132
TM195 26 Male 16 Single 3 3 50028 85
TM195 27 Female 14 Partnered 3 2 45480 66
TM195 27 Male 16 Single 4 3 54576 85
TM195 27 Female 14 Partnered 2 3 45480 56
TM195 28 Female 14 Partnered 2 3 46617 56
TM195 28 Female 16 Partnered 2 3 52302 66
TM195 28 Male 14 Single 3 3 52302 103
TM195 28 Female 14 Partnered 3 3 54576 94
TM195 28 Male 14 Single 4 3 54576 113
TM195 28 Female 16 Partnered 3 3 51165 56
TM195 29 Male 18 Partnered 3 3 68220 85
TM195 29 Female 14 Partnered 2 2 46617 38
TM195 29 Female 16 Partnered 4 3 50028 94
TM195 30 Male 14 Partnered 4 4 46617 141
TM195 30 Male 14 Single 3 3 54576 85
TM195 31 Male 14 Partnered 2 2 54576 47
TM195 31 Female 14 Single 2 2 45480 47
TM195 32 Female 14 Single 3 4 46617 113
TM195 32 Male 14 Partnered 4 3 52302 85
TM195 33 Female 16 Single 2 2 55713 38
TM195 33 Female 16 Partnered 3 3 46617 85
TM195 34 Male 16 Single 4 5 51165 169
TM195 34 Female 16 Single 2 2 52302 66
TM195 35 Male 16 Partnered 4 3 48891 85
TM195 35 Female 16 Partnered 3 3 60261 94
TM195 35 Female 18 Single 3 3 67083 85
TM195 36 Male 12 Single 4 3 44343 94
TM195 37 Female 16 Partnered 3 3 37521 85
TM195 38 Male 16 Partnered 3 3 46617 75
TM195 38 Female 14 Partnered 2 3 54576 56
TM195 38 Male 14 Single 2 3 52302 56
TM195 38 Male 16 Partnered 3 3 56850 75
TM195 39 Male 16 Partnered 4 4 59124 132
TM195 40 Male 16 Partnered 3 3 61398 66
TM195 41 Male 16 Partnered 4 3 54576 103
TM195 43 Male 16 Partnered 3 3 53439 66
TM195 44 Female 16 Single 3 4 57987 75
TM195 46 Female 16 Partnered 3 2 60261 47
TM195 47 Male 16 Partnered 4 3 56850 94
TM195 50 Female 16 Partnered 3 3 64809 66
TM498 19 Male 14 Single 3 3 31836 64
TM498 20 Male 14 Single 2 3 32973 53
TM498 20 Female 14 Partnered 3 3 34110 106
TM498 20 Male 14 Single 3 3 38658 95
TM498 21 Female 14 Partnered 5 4 34110 212
TM498 21 Male 16 Partnered 2 2 34110 42
TM498 21 Male 12 Partnered 2 2 32973 53
TM498 23 Male 14 Partnered 3 3 36384 95
TM498 23 Male 14 Partnered 3 3 38658 85
TM498 23 Female 16 Single 3 3 45480 95
TM498 23 Male 16 Partnered 4 3 45480 127
TM498 23 Female 16 Partnered 3 2 43206 74
TM498 23 Female 14 Single 3 2 40932 53
TM498 23 Male 16 Partnered 3 3 45480 64
TM498 24 Female 14 Single 3 2 40932 85
TM498 24 Male 14 Single 3 4 48891 106
TM498 24 Female 16 Single 3 3 50028 106
TM498 25 Female 14 Partnered 2 3 45480 85
TM498 25 Female 14 Single 3 4 43206 127
TM498 25 Male 16 Partnered 2 2 52302 42
TM498 25 Female 14 Partnered 5 3 47754 106
TM498 25 Male 14 Single 3 3 45480 95
TM498 25 Female 14 Single 2 3 43206 64
TM498 25 Male 14 Partnered 4 3 45480 170
TM498 25 Male 14 Partnered 3 4 43206 106
TM498 25 Male 16 Partnered 2 3 50028 53
TM498 25 Female 14 Single 2 2 45480 42
TM498 25 Male 14 Single 4 3 48891 127
TM498 26 Female 16 Partnered 4 3 45480 85
TM498 26 Female 16 Single 4 4 50028 127
TM498 26 Male 16 Single 4 3 51165 106
TM498 27 Male 14 Single 4 2 45480 53
TM498 29 Female 14 Partnered 3 3 51165 95
TM498 30 Female 14 Single 3 3 57987 74
TM498 30 Female 13 Single 4 3 46617 106
TM498 31 Male 16 Partnered 3 3 52302 95
TM498 31 Female 16 Partnered 2 3 51165 64
TM498 31 Female 18 Single 2 1 65220 21
TM498 32 Male 16 Single 4 3 60261 127
TM498 32 Male 16 Partnered 3 3 53439 95
TM498 33 Male 13 Partnered 4 4 53439 170
TM498 33 Female 16 Partnered 2 3 50028 85
TM498 33 Male 16 Partnered 3 3 51165 95
TM498 33 Female 16 Partnered 5 3 53439 95
TM498 33 Female 18 Single 3 4 47754 74
TM498 34 Female 16 Partnered 4 3 64809 95
TM498 34 Male 16 Partnered 3 4 59124 85
TM498 34 Male 15 Single 3 3 67083 85
TM498 35 Female 14 Partnered 3 2 52302 53
TM498 35 Male 16 Partnered 3 2 53439 53
TM498 35 Female 16 Single 3 2 50028 64
TM498 35 Male 16 Partnered 3 3 53439 95
TM498 37 Female 16 Partnered 2 3 48891 85
TM498 38 Female 16 Partnered 4 3 62535 85
TM498 38 Male 16 Partnered 3 3 59124 106
TM498 40 Female 16 Partnered 3 3 61398 85
TM498 40 Female 16 Single 3 3 57987 85
TM498 40 Male 16 Partnered 3 3 64809 95
TM498 45 Male 16 Partnered 2 2 54576 42
TM498 48 Male 16 Partnered 2 3 57987 64
TM798 22 Male 14 Single 4 3 48658 106
TM798 22 Male 16 Single 3 5 54781 120
TM798 22 Male 18 Single 4 5 48556 200
TM798 23 Male 16 Single 4 5 58516 140
TM798 23 Female 18 Single 5 4 53536 100
TM798 23 Male 16 Single 4 5 48556 100
TM798 24 Male 16 Single 4 5 61006 100
TM798 24 Male 18 Partnered 4 5 57271 80
TM798 24 Female 16 Single 5 5 52291 200
TM798 24 Male 16 Single 5 5 49801 160
TM798 25 Male 16 Partnered 4 5 49801 120
TM798 25 Male 16 Partnered 4 4 62251 160
TM798 25 Female 18 Partnered 5 5 61006 200
TM798 25 Male 18 Partnered 4 3 64741 100
TM798 25 Male 18 Partnered 6 4 70966 180
TM798 25 Male 18 Partnered 6 5 75946 240
TM798 25 Male 20 Partnered 4 5 74701 170
TM798 26 Female 21 Single 4 3 69721 100
TM798 26 Male 16 Partnered 5 4 64741 180
TM798 27 Male 16 Partnered 4 5 83416 160
TM798 27 Male 18 Single 4 3 88396 100
TM798 27 Male 21 Partnered 4 4 90886 100
TM798 28 Female 18 Partnered 6 5 92131 180
TM798 28 Male 18 Partnered 7 5 77191 180
TM798 28 Male 18 Single 6 5 88396 150
TM798 29 Male 18 Single 5 5 52290 180
TM798 29 Male 14 Partnered 7 5 85906 300
TM798 30 Female 16 Partnered 6 5 90886 280
TM798 30 Male 18 Partnered 5 4 103336 160
TM798 30 Male 18 Partnered 5 5 99601 150
TM798 31 Male 16 Partnered 6 5 89641 260
TM798 33 Female 18 Partnered 4 5 95866 200
TM798 34 Male 16 Single 5 5 92131 150
TM798 35 Male 16 Partnered 4 5 92131 360
TM798 38 Male 18 Partnered 5 5 104581 150
TM798 40 Male 21 Single 6 5 83416 200
TM798 42 Male 18 Single 5 4 89641 200
TM798 45 Male 16 Single 5 5 90886 160
TM798 47 Male 18 Partnered 4 5 104581 120
TM798 48 Male 18 Partnered 4 5 95508 180