Question

Hello! This is business statistics and i want to know the answer.

Please answer these questions with explanation.

Thanks you very much for helping me^^

From the dropdown in the purple cells (range A4:F4), select the correct scale of measurement Display Size CPU (inches) Operating Battery Life System Tablet Manufacturer Cost ($) (hours) Tablet Acer Iconia W510 Amazon Kindle Fire HD Apple iPad 4 HP Envy X2 Lenono Think Pad MS Surface Pro Motorola Driod Xyboard Samsung Ativ Smart PC Samsung Galaxy Tab Sony S Cost (S) Operating System Display Size (inches) Battery Life (hours) CPU Manufacturer 8.5 Intel 599 Windows 299 Andriod 499 iOS 860 Windows 668 Windows 899 Windows 530 Andriod 590 Windows 525 Andriod 360 Andriod 10.1 8.9 9.7 11.6 10.1 10.6 10.1 11.6 10.1 9.4 9TI OMAP 11 Apple 8 Intel 10.5 Intel 4 Intel 9TI OMAP 7 Intel 10 Nvidia 8 Nvidia 1 In cell B10 calculate the average compounding rate earned from the below investment. 4 2003 $12,500.00 2014 $23,120.34 Year Invested Amount invested in 2003 Year Withdrawn Amount Withdrawn 6 9 average compounding rate (geometric mean) 10 If the Mean Gas Price is $2.25 with a Standard Deviation of $0.11 and the distribution of gas prices is bell shaped, approximately 95.00% of the gas prices should be between what two values? Somewhere on the sheet make your calculations L Mean Gas Price $2.25 Standard Deviation Percentage $0.11 95% Jr | しalcul ate tne z score Tor eacn。T tne sample gas prices, somewhere on tne sneet, write a statement about what the z score mea 1 Calculate the z score for each of the sample gas prices. Somewhere on the sheet, write a statement about what the z score means 2 bas Prices z Score 2.48 2.53 2.42 2.47 2.57 2.6 2.38 2.67 2.31 2.06 2.53 2.34 2.52 2.31 2.43 2.55 2.27 2.2 2.54 2.42 2.53 2.33 2.37 10 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 28

Answer 1

Z Score -

A z-test is a statistical test used to determine whether two population means are different when the variances are known and the sample size is large. The test statistic is assumed to have a normal distribution, and nuisance parameters such as standard deviation should be known in order for an accurate z-test to be performed.

A.T.Q

From the samples given above we will calculate the mean to be used in the z test statistic.

Mean ( Gas Prices) =2.427391

For understanding of Z test statistics-

8 6- Copy " aste B I u Home Insert Page File Format Painter Cut a Copy Format Painter Clipboard Calibri 27 Clipboard 2.48 2.53 2.42 2.47 B27 13 14 15 16 2.52 2.31 2.43 2.55 172.27 2.2 2.54 2.42 2.53 2.33 2.37 24 55.83 2.57 2.6 2.38 2.67 2.31 2.06 2.53 2.34 . 2.52 2.31 2.43 2.55 2.27 2.2 2.54 2.42 2.53 2.33 18 19 20 21 25 2.427391 7 2.37

Z-TEST Formula to find the value of Z (z-test) Is: mean of sample μ mean of population σ -standard deviation of population n -no. of observations

A.T.Q.

n=23

$\mu$= 2.25

$\sigma$= 0.11

mean(x)=2.42731

z= 7.733989

Hence the value of z score is 7.733989