Question

In: Statistics and Probability

Second, the researcher wishes to use graphical descriptive methods to present summaries of the data on...

Second, the researcher wishes to use graphical descriptive methods to present summaries of the data on each of the two variables: hours worked per week and income earned per year, as stored in HOURSWORKED63 worksheet.

(a) The number of observations (n) is 63 individuals. The researcher suggests using 7 class intervals to construct a histogram for each variable. Explain how the researcher would have decided on the number of class intervals (K) as 7.

Data of HOURSWORKED63 Excel spraedsheet is below:

Yearly Income ('000's) Hours Per Week
43.8 18
44.5 13
44.8 18
46.0 25.5
41.4 11.6
43.3 18
43.6 16
46.2 27
46.8 27.5
48.2 30.5
49.3 24.5
53.8 32.5
53.9 25
54.2 23.5
50.5 30.5
51.2 27.5
51.5 28
52.6 26
52.8 25.5
52.9 26.5
49.5 33
49.8 15
50.3 27.5
54.3 36
55.1 27
55.3 34.5
61.7 39
62.3 37
63.4 31.5
63.7 37
55.5 24.5
55.6 28
55.7 19
58.2 38.5
58.3 37.5
58.4 18.5
59.2 32
59.3 35
59.4 36
60.5 39
56.7 24.5
57.8 26
63.8 38
64.2 44.2
55.8 34.5
56.2 34.5
64.3 40
64.5 41.5
64.7 34.5
66.1 42.3
72.3 34.5
73.2 28
74.2 38
68.5 31.5
69.7 36
71.2 37.5
66.3 22
66.5 33.5
66.7 37
74.6 43.5
62.0 20
57.3 35
55.3 24

Solutions

Expert Solution


Related Solutions

Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of...
Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of the two variables: hours worked per week and income earned per year. b. Compute the correlation coefficient using the relevant Excel function to measure the direction and strength of the linear relationship between the two variables. Display and interpret the correlation value.      Data for HOURSWORKED63 Excel spreadsheet is below: Yearly Income ('000's) Hours Per Week 43.8 18 44.5 13 44.8 18 46.0 25.5...
Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of...
Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of the two variables: hours worked per week and income earned per year. (a) Prepare and display a numerical summary report for each of the two variables including summary measures such as mean, median, range, variance, standard deviation, smallest and largest values and the three quartiles. Notes: Use QUARTILE.EXC command to generate the three quartiles. Data for HOURSWORKED63 Excel spreadsheet is below: Yearly Income ('000's)...
4. the researcher wishes to use numerical descriptive measures to summarize the data on each of...
4. the researcher wishes to use numerical descriptive measures to summarize the data on each of the two variables: hours worked per week and income earned per year. Prepare and display a numerical summary report for each of the two variables including summary measures such as mean, median, range, variance, standard deviation, smallest and largest values and the three quartiles.                               Notes: Use QUARTILE.EXC command to generate the three quartiles. Compute the correlation coefficient using the relevant Excel function...
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to...
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to summarize the sample data in the data set named PelicanStores in Case 1 folder. The managerial report should contain summaries such as: 1. A frequency and relative frequency distributions for the methods of payment (different cards). (20%) 2. Mean, median, first quartile, third quartile, and sample standard deviation for net sales from regular customers. (20%) 3. Mean, median, first quartile, third quartile, and sample...
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to...
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to summarize the sample data in the data set named PelicanStores in Case 1 folder. The managerial report should contain summaries such as: 1. A frequency and relative frequency distributions for the methods of payment (different cards). (20%) 2. Mean, median, first quartile, third quartile, and sample standard deviation for net sales from regular customers. (20%) 3. Mean, median, first quartile, third quartile, and sample...
(please provide detailed solution with formula and figures) the researcher wishes to use numerical descriptive measures...
(please provide detailed solution with formula and figures) the researcher wishes to use numerical descriptive measures to summarize the data on each of the two variables: hours worked per week and yearly income. a) Prepare and display a numerical summary report for each of the two variables including summary measures such as mean, median, range, variance, standard deviation, smallest and largest values and the three quartiles. Notes: Use QUARTILE.EXC command to generate the three quartiles. b) Compute the correlation coefficient...
use methods of descriptive statistics to summarize the data and comment on your findings - Income...
use methods of descriptive statistics to summarize the data and comment on your findings - Income ($1000s) Household Size Amount Charged ($) 54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27 1 2,477 33 2 2,514 65 3 4,214 63 4 4,965 42 6 4,412 21 2 2,448 44 1 2,995 37...
. Descriptive information and graphical displays of the top three reasons coming to the university (use...
. Descriptive information and graphical displays of the top three reasons coming to the university (use Statcrunch) [GO to Stat, Tables, Frequency, Select columns (use SHIFT Key to choose the block of variables). Select Statistics: Choose all five (use Ctrl key), Compute]. You see the output. Look for the top three reasons to report in (a). Use table to summarize the frequency of ‘reasons’ for choosing the university. What are the top three reasons:       [1: Yes, and 0: No]...
(the solution for this question is not available, please answer complete) Second, the researcher wishes to...
(the solution for this question is not available, please answer complete) Second, the researcher wishes to use graphical descriptive methods to present summaries of the data on each of the two variables: hours worked per week and yearly income, as stored in file HOURSWORKED.xls. a) The number of observations (n) is 65 individuals. The researcher suggests using 7 class intervals to construct a histogram for each variable. Explain how the researcher would have decided on the number of class intervals...
Use methods of descriptive statistics to summarize the data. Comment on the findings. Please include formulas used and steps to complete it.
Use methods of descriptive statistics to summarize the data. Comment on the findings. Please include formulas used and steps to complete it. Data: Golfer Earnings ($1000s) Scoring Avg. Greens in Reg. Putting Avg. Ai Miyazato 57017 72.00 0.702 30.04 Alena Sharp 27127 72.80 0.689 30.65 Alison Lee 136411 70.72 0.716 29.17 Alison Walshe 66038 72.45 0.653 29.55 Amelia Lewis 16524 73.33 0.636 29.72 Amy Anderson 20459 73.40 0.708 31.60 Amy Yang 470755 70.47 0.752 30.03 Angela Stanford 93913 71.46 0.718...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT