Expert answer:Create a histogram (Actual Graph) based on the pri
Solved by verified expert:you will find the direction in the document
homework_3.docx
ipad_index.xlsx
Unformatted Attachment Preview
Homework 3
Problem 1. Download the Ipad Index.xlsx from canvas.
1. Create a histogram (Actual Graph) based on the price data, Bin 1 and Bin 2. You need to create
two graphs for this part.
2. Draw Pie charts based on the number of frequencies that found from part 1. Also, you need two
create two Pie charts.
3. Which Bin size gives you better pie chart? Share your opinion.
Frequency
15
10
5
Frequency
0
Frequency
$500
$550
$600
$650
$700
$750
$800
$850
$900
$950
Problem 2. Dr. Strangelove has spent a lot of time and money on his new invention – Peacemaker – and
now the experiment is complemented. You, as his No.1 assistant, need to run some analysis on the data
that he collected from the experience. Assist Dr. Strangelove by completing the Table 2.
X
1
Y
5
Z
W
4.712389 18.39397
2
3
4
5
6
7
8
9
10
7
9
11
13
15
17
19
21
23
7.068583
10.60288
15.90431
23.85647
35.7847
53.67706
80.51558
120.7734
181.1601
6.766764
2.489353
0.915782
0.336897
0.123938
0.045594
0.016773
0.00617
0.00227
Table 1. Data on Dr. Strangelove’s new Peacemaker experiment
R2 Value
X-Y
X-Z
X-W
Linear
Power
Table 2. R2 Value
Exponential
IPAD INDEX
Country
Price (US
Dollars)[12][13][
14][15]
Argentina
$1.094,11
Bin 1
Bin 2
$500
$500
$600
$550
$700
$600
$800
$650
$900
$700
$1.000
$750
Australia
$506,66
Austria
$674,96
Belgium
$618,34
Brazil
$791,40
Brunei
$525,52
Canada
(Montréal)
$557,18
$800
Canada (no
tax)
$467,36
Chile
$602,13
China
$602,52
$850
$900
$950
Czech
Republic
$676,69
Denmark
$725,32
Finland
$695,25
France
$688,49
Germany
$618,34
Greece
$715,54
Hong Kong
$501,52
Hungary
$679,64
India
$512,61
Ireland
$630,73
Italy
$674,96
Japan
$501,56
Luxembourg
$641,50
Malaysia
$473,77
Mexico
$591,62
Netherlands
$683,08
New Zealand
$610,45
Norway
$655,92
Philippines
$556,42
Poland
$704,51
Portugal
$688,49
Russia
$596,08
Singapore
$525,98
Slovakia
$674,96
Slovenia
$674,96
South Africa
$559,38
South Korea
$576,20
$1.000
Spain
$674,96
Sweden
$706,87
Switzerland
$617,58
Taiwan
$538,34
Thailand
$530,72
Turkey
$656,96
UAE
$544,32
United
Kingdom
$638,81
US
(California)
$546,91
US (no tax)
$499,00
Vietnam
$554,08
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades