logo

Assignment on Frequency Distribution

7 Pages1102 Words124 Views
   

Added on  2021-06-17

Assignment on Frequency Distribution

   Added on 2021-06-17

ShareRelated Documents
Question 1:a)From the data using excel we find out that, Minimum=$123 ,Maximum= $490 i.e. Range=$490-$123=$367.We have a dataset of 50 observations. We have to make frequency distribution, relative frequency distribution, percentage frequency distribution with class width of $50Next, we divide the data range into 5 parts.Frequency Distribution:Furniture portion of each order(in dollars)Frequency120-1708170-22015220-27012270-3204320-3705370-4202420-4702470-5202Table 1:Frequency Distribution showing furniture portion of the 50 ordersRelative Frequency Distribution:Furniture portion of each order(in dollars)Relative Frequency120-1700.16170-2200.3220-2700.24270-3200.08320-3700.1370-4200.04420-4700.04470-5200.04Table 2: Relative Frequency Distribution showing furniture portion of the 50 orders
Assignment on Frequency Distribution_1
Percentage frequency Distribution:Furniture portion of each order(in dollars)Percentage Frequency120-17016170-22030220-27024270-3208320-37010370-4204420-4704470-5204Table 3: Percentage Frequency Distribution showing furniture portion of the 50 ordersb)Furniture portion of each order(in dollars)Percentage Frequency120-17016170-22030220-27024270-3208320-37010370-4204420-4704470-5204From the above percentage Frequency table we get the following Histogram by using Excel:
Assignment on Frequency Distribution_2
120-170170-220220-270270-320320-370370-420420-470470-52005101520253035Percentage frequency Histogram showing furniture portionDiagram 1: Percentage Frequency Histogram Showing Furniture portion of OrdersFrom the percentage frequency histogram we get that the furniture portion of each order follows a positively skewed distribution i.e. a right skewed distribution.c)As the data is a skewed data, so median would be a good measure of location for this dataset.Question 2:a)The Regression output shows the anova table of relating to the variables Y(demand), X(Price).H0:TheestimatedregressionequationdoesnotrepresentasignificantrelationshipbetweenY∧XagainstH1:notH0Here Y(demand) is the response variable and X(Price) is the independent variable.Here SSR=5048.818 (SSR=Sum of Squares due to Regression) and SSRes =3132.661 ( SSRes = Sum of Squares due to Residuals) Here degrees of freedom for the SSR part is 1 and for SSRes part Df=46 .
Assignment on Frequency Distribution_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Frequency Distribution, Regression Analysis, ANOVA and Interpretation of Results
|13
|2207
|492

Deslib - Statistics Assignment Solution
|15
|2468
|269

Frequency Distribution, Hypothesis Testing, Regression Analysis
|2
|757
|346

Calculations and Graphing Representations Assignment PDF
|9
|656
|118

Statistics: Frequency Distribution, Regression Analysis, and Hypothesis Testing
|5
|835
|148

Understanding the Digital Revolution: Hat Bonanza
|6
|846
|62