Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started