*Work the problems in EXCEL. 1. Problem 1: =======>>>>>>Open data files: JeepSales.xlsx and JeepTable.xlsx ( copy this) (a) Learn...

70.2K

Verified Solution

Question

Basic Math

*Work the problems in EXCEL.

1. Problem 1:

=======>>>>>>Open data files: JeepSales.xlsx andJeepTable.xlsx ( copy this)

(a) Learn the PivotTable to derive JeepTables.xlsx fromJeepSales.xlsx. [Hint: Click Insert,Â Â

PivotTable, highlight the data]

(b) Construct a Frequency Bar chart, Pie chart.Â Â

Reduce graph size. Copy/paste into a MS Word file.
Jeep Model
W
L
G
L
G
C
L
G
C
G
L
W
L
G
W
G
L
W
W
G
L
L
L
G
L
G
L
G
L
W
L
G
L
G
L
C
C
W
C
G
L
G
G
L
C
C
C
G
L
L
C
G
L
C
W
G
G
W
C
W
W
L
C
L
L
C
G
L
G
L
C
W
C
G
G
L
L
C
W
L
G
C
C
G
C
C
L
C
G
C
G
G
C
W
W
L
C
C
L
L
C
C
C
L
L
C
C
L
L
G
L
C
G
G
C
C
L
C
G
C
C
G
C
C
L
C
C
L
W
C
L
W
C
L
W
L
W
G
W
L
L
C
C
W
L
C
L
G
W
C
W
W
L
L
C
L
L
G
L
G
C
C
G
G
C
C
L
L
L
W
C
G
G
L
W
G
L
L
L
G
L
G
G
L
G
G
G
C
C
C
G
L
G
C
C
G
C
G
L
W
G
C
L
G
L
C
G
C
C
L
G
L
G
C
L
G
G
C
G
G
W
L
G
L
C
C
L
L
C
L
C
G
L
L
C
L
C
G
G
G
C
W
G
G
L
W
L
G
G
L
L

2. Problem 2: Â Â

=========>>>>>>Open data file: Design.xlsx.Construct,

(a) A Histogram with a revised Bin size. (Bin width=2).Â Â

(b) A Frequency Polygon.Â Â

(c) A Cumulative Percentage Histogram (ogive).

Reduce size. Copy and paste into the MS Word file.
Rating
34
32
24
32
31
32
33
25
30
28
28
30
33
27
20
30
33
34
29
33
34
31
31
32
26
22
31
31
32
30
33
27
32
33
28
30
28
32
30
29
26
32
25
33
35
27
29
31
32
32
33
34
32
29
33
29
31
31
34
33

Answer & Explanation Solved by verified expert

3.7 Ratings (384 Votes)

a Learn the PivotTable to derive JeepTablesxlsx fromJeepSalesxlsx Hint Click InsertPivotTable highlight the dataStep1 First bring data in to excel sheet Select the entiredata set2 Next go to Insert tab in the excel option and See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member