Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. *work the problems in excel. 1. problem 1: =====

*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

Other questions asked by students

Q

Which of the following is not an organic molecule composing hormones/hormone-like substances? prostaglandins proteins polysaccharides steroids

Medical Sciences
Q

a. Why are commercial or any aircraft that fly at altitude, pressurized? b. What is Pascal’s pressure...

Mechanical Engineering
Q

*****Will rate highly***** Please make sure to answer all 5 questions! Suppose you have landed successfully on...

Accounting
Q

You view the results for a full set of sugar fermentation tests for Neisseria gonorrhea....

Biology
Q

The person in the picture sights a pigeon ab

Geometry
Q

Consider the function f(x) = 8(x - 2)^2/3. For this function there are two important...

Basic Math
Q

Differentiate dy dx 4 y 16 4x 4

Calculus
Q

From the figure below estimate the weight W of a baby girl who is 1...

Algebra
Q

To obtain reasonable assurance that the financial statements are free from material misstatements,...

Accounting
Q

Can you please help me out with this problem. Thank you Required: Prepare...

Accounting
Q

Outdoor Luggage, Incorporated, makes high-end hard-sided luggage for sports equipment. Data concerning three of the...

Accounting
Q

Stocks with highly likely risk level, generally have lower return as the theory predicts. ...

Finance