(Solved by Humans)-Need help with 300 word paper. Please see detail below; Details:

Question

?Need help with 300 word paper. ?Please see detail below;

Details:

Conduct an analysis and hypothesis test if property lot size has any relationship to men hrs. spent on property. Write a 300 word research summary of the findings (see attachments). The research summary should address the following.

1. Explain what type of analysis and hypothesis test was conducted on the data collected.
2. Summarize the survey results based on the results of the data you analyzed.
3. Include the Excel analysis as part of the document.

APA format is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Men
hrs./mont
hly
34.4
25.8
25.8
34.4
68.8
25.8
34.4
17.2
34.4
68.8
68.8
17.2
25.8
17.2
32.25
17.2
25.8
43
516
43
68.8
25.8
25.8
60.2
34.4
43
43
25.8
34.4
17.2
34.4
68.8
34.4
43
19.35
68.8
32.25
12.9
43
43
38.7
34.4
43
344
25.8
25.8
34.4
25.8
25.8
34.4
60.2
25.8

Monthly
current
fee
$700.00
$500.00
$500.00
$600.00
$850.00
$450.00
$550.00
$400.00
$550.00
$1,500.00
$1,600.00
$495.00
$550.00
$500.00
$750.00
$350.00
$600.00
$750.00
$10,000.00
$1,100.00
$900.00
$600.00
$600.00
$1,300.00
$650.00
$1,000.00
$900.00
$500.00
$750.00
$450.00
$750.00
$1,100.00
$575.00
$1,250.00
$475.00
$850.00
$900.00
$475.00
$800.00
$900.00
$700.00
$500.00
$750.00
$6,000.00
$600.00
$550.00
$600.00
$500.00
$650.00
$650.00
$1,900.00
$550.00

Per hour
rate with
current
monthly
fee
$20.35
$19.38
$19.38
$17.44
$12.35
$17.44
$15.99
$23.26
$15.99
$21.80
$23.26
$28.78
$21.32
$29.07
$23.26
$20.35
$23.26
$17.44
$19.38
$25.58
$13.08
$23.26
$23.26
$21.59
$18.90
$23.26
$20.93
$19.38
$21.80
$26.16
$21.80
$15.99
$16.72
$29.07
$24.55
$12.35
$27.91
$36.82
$18.60
$20.93
$18.09
$14.53
$17.44
$17.44
$23.26
$21.32
$17.44
$19.38
$25.19
$18.90
$31.56
$21.32

68.8
34.4

$1,000.00
$700.00

$14.53
$20.35

Part 1:
The best estimate of the population mean is the sample mean which are,
Per hour rate with
Men hrs./monthly
Monthly current fee
current monthly fee
Sample mean
51.4009259259
1012.4074074074
20.9664814815

b)

95% confidence interval
Lower Value Upper Value

90% confidence interval
Lower Value
Upper Value

98% confidence interval
Lower Value

Men
hrs./mont
hly

30.0091

72.7927

33.5460

69.2558

25.8172

Monthly
current
fee

$611.21

$1,413.60

$677.55

$1,347.27

$532.59

Per hour
rate with
current
monthly
fee

$19.65

$22.28

$19.87

$22.06

$19.40

% confidence interval
Upper Value

76.9847

$1,492.22

$22.54

c)

For 95% confidence interval, we are 95% confident that the respective population mean falls within the interval.
For 90% confidence interval, we are 95% confident that the respective population mean falls within the interval.
For 98% confidence interval, we are 95% confident that the respective population mean falls within the interval.

n falls within the interval.
n falls within the interval.
n falls within the interval.