Create a histogram (Actual Graph) based on the price data

User Generated

EF97

Business Finance

Description

you will find the direction in the document

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here you go bro, I attached 3 files...One is the solution in Excel, and the other two are the responses in word and in .pdf

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 ta...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags