MGSC209 Car Selling Company Location & Brands Excel Sheet Statistics Homework There are three different datasets, and each one have different answer sheet

MGSC209 Car Selling Company Location & Brands Excel Sheet Statistics Homework There are three different datasets, and each one have different answer sheet which includes the questions. Please provide the work steps on the worksheets. Copyright © 2019, Udaptive.
All Rights Reserved.
How to enable Macros
FaQ
What will be considered for grading?
Only “Answer” Sheets will be considered for grading.
Can I add additional worksheets?
Yes.
What is the best way to present my solution?
Complete your work in your worksheet and reference or “hardcode” your answer in the yellow
cells provided in the “Answer” sheet.
Why is my formula not working in Excel?
Check for Automatic Calculation. On the Formulas ribbon [Excel Opions], look to the far right
and click Calculation Options. When this option is set to automatic, Excel recalculates the
spreadsheet’s formulas whenever you change a cell value.
Terms of Use
This template is considered a copyrighted work under the Unites States and other copyright laws and is
the
property of Udaptive. The items listed below are additional points to help clarify how you may use this template.
Not for Resale or Public Sharing
You may make archival copies and customize this template only for your personal use and not for
resale sharing.
or
public
You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use,
attribution, or other proprietary notices or marks within this template.
This template and any customized or modified version of this template may NOT be sold, distributed,
published to an online gallery, hosted on a website, or placed on a public server.
Disclaimer
This template is provided for informational or educational use only and is not intended to be relied on as medical,
financial, legal, or other professional advice.
Udaptive makes no guarantee or representations about this template, or the accuracy or completeness of the
content contained within this template.
Location (saved)
User_ID
AnswerSheets
Course
3
Please answer all questions based on the data provided below and ‘Dataset_1’. If you cannot answer the question due to
data, enter ‘NA’. Do not change the formatting of the yellow cells. Round to three digits after decimal.
1) How many customers applied for new-car, used-car, business, education, small-appliance, and furniture loans?
New Car
Used Car
Education
Business
Small Appliance
Retraining
2) Count the number of customers with checking account balances less than $300.
3)
Create new columns that classify the checking and savings account balances as low if the balance is less than $300, m
less than $2200, and high otherwise. Count your the low, medium and high categories.
LOW
MEDIUM
HIGH
Checking
Savings
4) What is the average checking balance for customers that applied for…
New Car
Furniture
Education
answer the question due to insufficient
r decimal.
, and furniture loans?
balance is less than $300, medium if between $300 but
Dataset_1
Loan Purpose
Small Appliance
Furniture
Used Car
Furniture
Education
Furniture
New Car
Education
Furniture
Small Appliance
Business
New Car
Business
Retraining
New Car
Used Car
Furniture
New Car
Repairs
Education
Furniture
Small Appliance
Furniture
Furniture
New Car
Business
Used Car
Used Car
Small Appliance
Small Appliance
Education
Small Appliance
Small Appliance
Business
Business
Small Appliance
Furniture
Small Appliance
Small Appliance
New Car
Other
Used Car
Small Appliance
Furniture
Furniture
Assume a clean dataset.
Checking
$
9,323
$
5,031
$
5,706
$
2,148
$
8,563
$
8,536
$
8,588
$
3,499
$
$
$
11,172
$
1,065
$
7,308
$
11,222
$
3,929
$
6,216
$
945
$
12,610
$
$
$
5,362
$
$
$
10,296
$
$
$
4,484
$
4,177
$
9,868
$
$
7,460
$
8,694
$
$
$
280
$
2,070
$
8,786
$
12,066
$
6,942
$
1,361
$
4,369
$
5,593
$
261
$
5,252
$
–
Savings
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,967
717
1,605
3,575
1,230
2,597
2,450
2,325
796
3,853
2,717
217
3,146
3,639
2,282
2,292
2,876
–
Small Appliance
Furniture
New Car
Business
Small Appliance
Small Appliance
Furniture
Business
New Car
Used Car
Education
Furniture
New Car
New Car
Furniture
New Car
New Car
Small Appliance
New Car
Small Appliance
Small Appliance
Business
Used Car
Furniture
Furniture
New Car
Small Appliance
Business
Furniture
Small Appliance
Used Car
Business
Business
Repairs
Business
New Car
Education
New Car
Education
New Car
Small Appliance
Used Car
Small Appliance
Small Appliance
Furniture
Education
Small Appliance
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
5,146
5,195
7,608
12,852
820
3,941
6,838
9,688
8,349
1,875
11,297
6,663
6,633
1,584
6,686
6,359
733
2,172
10,627
4,910
9,083
7,960
10,689
3,246
203
1,005
964
8,745
1,411
12,620
6,006
6,778
1,052
4,758
6,587
9,562
126
9,123
6,498
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,138
1,370
702
414
2,803
2,900
3,377
2,942
2,646
3,249
2,520
1,271
491
1,420
740
1,619
–
Repairs
Business
Small Appliance
Small Appliance
Small Appliance
New Car
Small Appliance
Furniture
Small Appliance
Used Car
Retraining
Furniture
New Car
Education
Business
Furniture
New Car
Used Car
Small Appliance
Furniture
Business
New Car
Furniture
Furniture
Small Appliance
Used Car
Large Appliance
Furniture
Furniture
Small Appliance
Small Appliance
Furniture
New Car
Used Car
New Car
Furniture
Small Appliance
Business
Furniture
Small Appliance
Small Appliance
Small Appliance
Other
Business
Repairs
New Car
Furniture
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,057
11,498
8,659
2,826
6,512
9,729
6,224
556
5,633
2,262
11,535
9,284
1,086
8,150
7,829
9,683
3,516
4,815
9,976
5,537
3,515
7,210
10,732
6,538
2,728
5,560
9,205
6,189
4,501
2,706
7,764
8,768
8,022
9,216
6,007
8,040
2,939
4,662
11,807
2,905
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
2,665
2,163
3,080
2,638
761
1,423
2,123
2,510
2,013
1,447
2,443
1,578
3,221
1,407
385
3,437
417
536
3,603
1,866
113
–
Furniture
Small Appliance
Small Appliance
Furniture
Small Appliance
Business
Repairs
Small Appliance
Furniture
New Car
New Car
Used Car
New Car
New Car
Used Car
Small Appliance
New Car
Used Car
Education
Furniture
Large Appliance
Furniture
Furniture
Business
Used Car
Small Appliance
Small Appliance
Used Car
Small Appliance
Repairs
Furniture
Used Car
New Car
New Car
Used Car
Repairs
Furniture
Used Car
Small Appliance
New Car
Business
Small Appliance
Small Appliance
Business
Furniture
Furniture
Small Appliance
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
11,372
1,022
8,394
2,296
3,357
992
6,449
12,843
9,786
2,475
5,211
10,834
6,538
8,364
8,587
274
11,562
2,661
6,676
11,382
9,807
10,449
494
11,706
3,954
4,810
2,389
10,923
6,282
10,640
7,540
12,822
12,030
2,859
968
5,659
12,523
5,437
3,031
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
21
1,637
2,240
1,778
1,760
35
2,590
1,810
97
1,110
3,815
3,965
818
954
683
–
Small Appliance
Furniture
Used Car
Business
New Car
New Car
Furniture
New Car
Small Appliance
Furniture
Small Appliance
Business
Small Appliance
New Car
Education
Used Car
New Car
New Car
Furniture
Small Appliance
Business
Other
Small Appliance
New Car
Small Appliance
New Car
Furniture
Business
Used Car
Used Car
Small Appliance
Small Appliance
Education
Small Appliance
Large Appliance
Education
Furniture
Business
New Car
Repairs
Furniture
Small Appliance
New Car
Small Appliance
Business
New Car
Small Appliance
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
234
6,449
4,210
3,265
1,469
8,963
5,082
3,363
8,245
6,948
4,807
9,087
7,362
8,021
370
4,908
3,054
10,837
8,754
2,413
8,629
4,722
659
9,432
5,094
3,726
11,474
9,535
11,708
556
2,881
9,501
8,626
12,113
12,789
5,689
4,485
373
7,282
7,110
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
3,404
2,203
1,001
1,719
1,084
741
195
2,466
2,678
2,216
670
–
Used Car
New Car
Small Appliance
Furniture
New Car
Used Car
Business
Furniture
Used Car
Small Appliance
Small Appliance
Business
Furniture
Small Appliance
Small Appliance
Used Car
New Car
Used Car
Small Appliance
Business
Education
Furniture
Business
Other
Furniture
New Car
New Car
Business
Used Car
Business
Small Appliance
New Car
New Car
Furniture
Repairs
Small Appliance
Small Appliance
Furniture
Furniture
Furniture
Furniture
Other
Education
Furniture
Small Appliance
Small Appliance
Small Appliance
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
8,034
9,656
12,968
2,909
8,615
12,740
11,311
10,864
807
12,323
10,176
8,698
3,525
2,081
4,543
8,971
11,583
7,401
11,162
5,290
1,116
8,108
7,804
12,028
6,621
6,396
12,961
1,768
5,418
9,508
3,567
11,942
7,958
12,869
9,175
4,185
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
3,750
3,125
2,411
3,695
3,536
267
2,722
2,231
2,199
3,477
167
2,549
1,102
609
–
Furniture
Education
Business
Small Appliance
Small Appliance
Furniture
Business
Business
Education
Education
Education
Business
Furniture
Small Appliance
Business
Business
Furniture
Small Appliance
Furniture
Small Appliance
Education
Business
Business
Business
Business
Business
Furniture
Business
Furniture
Business
Furniture
Furniture
Education
Business
Furniture
Education
Small Appliance
Small Appliance
Small Appliance
Furniture
Furniture
Small Appliance
Small Appliance
Furniture
Small Appliance
Business
Small Appliance
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
11,812
9,711
12,323
542
8,537
5,406
571
2,007
2,336
11,912
9,863
8,517
2,880
12,046
12,900
695
1,615
3,847
2,467
8,046
11,421
3,682
5,131
60
1,989
9,642
10,651
4,270
7,981
12,997
2,159
8,692
9,177
4,224
2,213
523
3,248
10,670
4,495
9,355
4,708
10,375
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
2,512
813
2,731
2,418
1,282
3,604
2,903
3,052
947
1,056
2,229
319
994
1,983
3,810
809
3,690
248
1,993
337
2,299
3,762
3,778
Furniture
Furniture
Furniture
Small Appliance
Business
Furniture
Education
Education
Business
Education
Business
Furniture
Business
Small Appliance
Education
Furniture
Business
Business
Education
Small Appliance
Small Appliance
Business
Small Appliance
Education
Small Appliance
Education
Furniture
Business
Small Appliance
Education
Small Appliance
Education
Business
Education
Business
Furniture
Education
Education
Business
Furniture
Small Appliance
Small Appliance
Education
Small Appliance
Education
Furniture
Small Appliance
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
8,966
10,460
9,891
7,996
7,811
8,280
8,559
9,594
3,283
9,282
4,442
10,648
7,868
6,535
644
12,944
4,986
2,329
5,758
5,372
9,834
10,840
11,472
5,441
8,365
1,090
228
7,388
1,903
10,104
5,212
5,489
7,154
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
3,184
3,526
2,533
510
2,962
2,658
61
2,489
1,736
2,517
376
2,753
1,523
3,349
2,698
2,951
1,392
2,999
–
Small Appliance
Furniture
Furniture
Education
Small Appliance
Small Appliance
Small Appliance
Business
Small Appliance
Small Appliance
Education
Furniture
Business
Furniture
Business
Business
Business
Business
Education
Small Appliance
Small Appliance
Small Appliance
Furniture
Small Appliance
Small Appliance
Business
Furniture
Small Appliance
Business
Small Appliance
Small Appliance
Small Appliance
Small Appliance
Furniture
Business
Furniture
Education
Small Appliance
Small Appliance
Furniture
Business
Small Appliance
Small Appliance
Small Appliance
Education
Small Appliance
Furniture
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
9,350
4,070
6,103
8,917
11,258
11,229
10,302
11,229
8,576
2,472
5,180
6,789
10,693
2,030
5,177
10,721
3,934
1,986
6,515
314
4,387
6,362
598
3,102
9,401
9,483
9,225
7,170
8,720
192
8,473
12,380
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,339
1,381
1,941
2,543
3,336
2,243
3,858
1,467
1,617
2,455
1,959
2,652
643
3,026
1,881
2,749
3,013
495
3,774
2,430
2,323
1,899
Education
Small Appliance
Furniture
Business
Furniture
Small Appliance
Small Appliance
Small Appliance
Small Appliance
Small Appliance
Education
Furniture
Education
Business
Small Appliance
Business
Small Appliance
Small Appliance
Small Appliance
Business
Education
Small Appliance
Furniture
Furniture
Furniture
Business
Small Appliance
Small Appliance
Small Appliance
Small Appliance
Business
Education
Small Appliance
Furniture
Education
Furniture
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
9,863
1,448
3,873
4,082
5,126
1,379
8,383
5,196
2,563
4,187
389
7,293
10,387
8,317
1,638
4,678
1,046
10,476
4,371
7,847
8,062
4,312
11,580
8,322
10,665
8,656
4,245
5,171
6,154
335
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,616
1,635
3,345
1,063
1,583
2,105
284
730
1,750
3,826
1,506
1,895
3,987
2,928
2,604
777
Please answer all questions based on the data provided below and ‘Dataset_2’. If you cannot answer the question due to
insufficient data, enter ‘NA’. Do not change the formatting of the yellow cells. Round to three digits after decimal.
1) How many cars did the company sell?
answer
2) What is the total revenue (in $) of the company?
answer
3) How many of each ‘Brand’ did the company sell? Identify and enter all ‘Brands’ in the dataset first.
sort in alphabetical order (A-Z)!
enter Brandname below
4) What is the revenue (in $) of each ‘Brand’? Identify and enter all ‘Brands’ in the dataset first.
sort in alphabetical order (A-Z)!
enter Brandname below
revenue in $
5) What is the revenue (in $) of each ‘VehicleType’? Identify and enter all ‘VehicleTypes’ in the dataset first.
sort in alphabetical order (A-Z)!
enter VehicleType below
revenue in $
6) What is the revenue (in $) of each ‘Location’? Identify and enter all ‘Locations’ in the dataset first.
sort in alphabetical order (A-Z)!
enter location below
revenue in $
7) How many new cars did the company sell? How much revenue (in $) did the company generate from selling new cars
count
revenue in $
new cars (mileage
Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
MGSC209 Car Selling Company Location & Brands Excel Sheet Statistics Homework There are three different datasets, and each one have different answer sheet
Just from $13/Page
Order Essay
Homework Writings Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Why should I choose Homework Writings Pro as my essay writing service?

We Follow Instructions and Give Quality Papers

We are strict in following paper instructions. You are welcome to provide directions to your writer, who will follow it as a law in customizing your paper. Quality is guaranteed! Every paper is carefully checked before delivery. Our writers are professionals and always deliver the highest quality work.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Reasonable Prices and Free Unlimited Revisions

Typical student budget? No problem. Affordable rates, generous discounts - the more you order, the more you save. We reward loyalty and welcome new customers. Furthermore, if you think we missed something, please send your order for a free review. You can do this yourself by logging into your personal account or by contacting our support..

Essay Delivered On Time and 100% Money-Back-Guarantee

Your essay will arrive on time, or even before your deadline – even if you request your paper within hours. You won’t be kept waiting, so relax and work on other tasks.We also guatantee a refund in case you decide to cancel your order.

100% Original Essay and Confidentiality

Anti-plagiarism policy. The authenticity of each essay is carefully checked, resulting in truly unique works. Our collaboration is a secret kept safe with us. We only need your email address to send you a unique username and password. We never share personal customer information.

24/7 Customer Support

We recognize that people around the world use our services in different time zones, so we have a support team that is happy to help you use our service. Our writing service has a 24/7 support policy. Contact us and discover all the details that may interest you!

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our reputation for excellence in providing professional tailor-made essay writing services to students of different academic levels is the best proof of our reliability and quality of service we offer.

Essays

Essay Writing Service

When using our academic writing services, you can get help with different types of work including college essays, research articles, writing, essay writing, various academic reports, book reports and so on. Whatever your task, homeworkwritingspro.com has experienced specialists qualified enough to handle it professionally.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our professional editor will check your grammar to make sure it is free from errors. You can rest assured that we will do our best to provide you with a piece of dignified academic writing. Homeworkwritingpro experts can manage any assignment in any academic field.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

See all services