Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can i get more explanation for this question please? Thank you Conduct a descriptive analysis on any 2 interval /ratio variables you wish using Descriptive_Statistics.xls

Can i get more explanation for this question please?

Thank you

Conduct a descriptive analysis on any 2 interval /ratio variables you wish using Descriptive_Statistics.xls and Frequency_Distribution.xls. Explain the output. 5.1 Descriptive Statistics 1. Q3 sales 2019

data.

- Median (Middle number in a data set) = 59868.00 - Mode (the data value that occurs most often in the data set) = N/A - Midrange (the average of the Minimum and maximum values) = 125417.50

Measures of Dispersion -Range (Difference between the maximum and the minimum.) = 177517.00 - Interquartile Range (Difference between the first and third quartiles) = 0.00 - Standard Deviation (Average weighted distance of all observations around the mean) = 41785.69 - Variance (The standard deviation squared) = 1746043870.79 - Coefficient of Variation (Gives a relative measure to the dispersion so you can determine if the standard deviation is truly large or small. It is computed as the standard deviation as a percentage of the mean) = 58.72%

Other measure - Sample Size (The total number of observations in the sample.) = 32 - Minimum (The smallest number in the data set)= 36659.00 - Maximum (The largest number in the data set)= 214176.00 - First Quartile (The observation such that 25% of the data is less than its value and 75% is greater than its value) = 0.00 - Third Quartile (The observation such that 75% of the data is less than its value and 25% is greater than its value) = 0.00 - Given percentile (For the kth percentile, k % of the observations fall below this value) = 90% 2. Number of cylinders

Measures of Central Tendency

- Mean (Also average, Sum of data items divided by number of data items) = 5.13 - Median (Middle number in a data set) = 4.00 - Mode (the data value that occurs most often in the data set) = 4.00 - Midrange (the average of the Minimum and maximum values) = 4.00

Measures of Dispersion -Range (Difference between the maximum and the minimum.) = 8.00 - Interquartile Range (Difference between the first and third quartiles) = 0.00 - Standard Deviation (Average weighted distance of all observations around the mean. It is used in conjunction with the mean to compute probabilities) = 1.90 - Variance (The standard deviation squared.) = 3.60 - Coefficient of Variation (Gives a relative measure to the dispersion so you can determine if the standard deviation is truly large or small) = 37.01%

Other measure - Sample Size (The total number of observations in the sample.) = 32 - Minimum (The smallest number in the data set)= 0.00 - Maximum (The largest number in the data set)= 214176.00 - First Quartile (The observation such that 25% of the data is less than its value and 75% is greater than its value) = 0.00 - Third Quartile (The observation such that 75% of the data is less than its value and 25% is greater than its value")= 0.00 - Given percentile (For the kth percentile, k % of the observations fall below this value) = 90%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pell And Pell–Lucas Numbers With Applications

Authors: Thomas Koshy

1st Edition

1461484898, 9781461484899

More Books

Students also viewed these Mathematics questions