A30 Sizzleking Burrito House MIN Frequency Distribution and Histogram This templ

Question

A30 Sizzleking Burrito House MIN Frequency Distribution and Histogram This template is designed to handle up to 150 observations. Enter data only in yellow cells DATA 2 78910 11 12 13 14 15 1-1.130 1.100/1.1701 1.0801 1.090 1.050| 1.090| 1.1201 100 1.070 1.070 1.150 1.130 0970 1.170 2 1.180 1.140 1.130 1.140 1.160 1.070 1.070 1.170 1.060 1.040 1.160 1.030 1.0801090 Enter n 1.170 1.080 1.140 1.130 1.150 1.050 1.070 1.090 1.110 1.090 1.030 1.070 1.090 1.060 Numbe 4 1.150 1.090 1.010 1.050 1.100 1090 1.030 1.090 1.020 1.140 1.080 1.11 0 1.080 1.0401 1.100 1.160 1.190 1.040 1.120 1.100 1.180 1.110 1.0501.130 1.140 1.130 1.030 1.1701.0901.160Enter 1.090 1.110 1.130 1.150 1.100 1.010 1.110 1.080 1.100 1.1101 1.110 1 1.010 1.030 1.120 1.130 1.200 1.100 1.200 1.070 0.960 1.180 1.110 1.130 1.070 1.17 1.100 1.060 1.120 1.170 1.180 1.130 1.040 1.060 1.110 1.060 1070 1.160 1.070 1.1001.100 1.020Lowe 1.030 1.050 1.140 1.100 1.090 1.090 1100 1.070 1.060 1.070 1.070 1.070 1.150 1.100 1.180 1.040 1.130 1.130 1.090 1.130 1150 1.180 1.170 1,100 1.150 1.080 1.090 1.120 1.150Cell 10 Histogram 1.100 0.0481 40 35 FreqDist and Histogram Sheet2

Explanation / Answer

See your first not there but other part are correct , You are going very well.

1)first part find using Excel path

Data >>>>>>Data Analysis >>>>>>>>>>> Descriptive statistics

2) Second part they say compute scatter plot please show scatter plot using this path

Select your both variable >>>>>>Insert >>>>>> Chart >>>>>Scatter

You get scatter plot

Also find correlation Using =COREL(Select first variable , Select second variable )

3) you are doing this part is very well where R squre is 0.756 whch is very strong .

4) In this part histogram is correct :) using frequency distribution.

5) see our above data analysis all the result are positive R squre is very good as well as histogram show normality .

that's why we suggest that there is no need of improove ment beacause all results are good .

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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