New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now

HI6007 Statistics for Business Decisions

Published : 18-Oct,2021  |  Views : 10

Question:

The data for Task 1 in the data file for Assignment represents the starting costs in thousands of dollars) for different kind of business.
1. Find mean, median, mode, range, variance and standard deviation separately for every type of business 
2. For every business type construct
a. frequency and relative frequency distributions starting from class 0 to 30
b. a relative frequency histogram 
3. Discuss the results obtained in parts 1 and 2 
4. Test if there significant difference in the starting costs for these types of business.

The data for Task 2 in the data file for Assignment represents the following variables for franchisees of All Greens Pty Ltd: annual sales ($’000), the floor area (sq.ft.’000), inventory ($’000), advertising expenditure ($’000), the size of the area where the business operates (number of families, ‘000) and the number of competitors in the area.
1. Present the MS Excel output and write down the estimated regression equation 
2. How well the model fits the data
3. Test the hypothesis that there is no significant relationship between the dependent and any of the independent variables
4. Interpret individual slope coefficients 
5. Construct a 95% confidence interval for the slope coefficients of individual variables
6. Test the estimated slope coefficients for individual variables for significance
7. Remove all insignificant variables and re-estimate the model 
8. Using the model from part (g), predict annual sales for a franchisee with 1,000 sq ft floor area, $150,000 inventory, $5,000 spent on advertising, 5,000 families in the area of operation and 2 competitors.

Answer:

X1 X2 X3 X4 X5 X6
231 3 294 8.199999809 8.199999809 11
156 2.200000048 232 6.900000095 4.099999905 12
10 0.5 149 3 4.300000191 15
519 5.5 600 12 16.10000038 1
437 4.400000095 567 10.60000038 14.10000038 5
487 4.800000191 571 11.80000019 12.69999981 4
299 3.099999905 512 8.1 10.10000038 10
195 2.5 347 7.699999809 8.4 12
20 1.200000048 212 3.299999952 2.099999905 15
68 0.600000024 102 4.900000095 4.699999809 8
570 5.400000095 788 17.39999962 12.30000019 1
428 4.199999809 577 10.5 14 7
464 4.699999809 535 11.30000019 15 3
15 0.600000024 163 2.5 2.5 14
65 1.200000048 168 4.699999809 3.299999952 11
98 1.600000024 151 4.599999905 2.700000048 10
398 4.300000191 342 5.5 16 4
161 2.599999905 196 7.199999809 6.300000191 13
397 3.799999952 453 10.39999962 13.89999962 7
497 5.300000191 518 11.5 16.29999924 1
528 5.599999905 615 12.30000019 16 0
99 0.800000012 278 2.799999952 6.5 14
0.5 1.100000024 142 3.099999905 1.600000024 12
347 3.599999905 461 9.6 11.30000019 6
341 3.5 382 9.800000191 11.5 5
507 5.099999905 590 12 15.69999981 0
400 8.6 517 7 12 8
Get An Awesome Price Quote For Your Paper – Absolutely FREE!
    Add File
    Files Missing!

    Please upload all relevant files for quick & complete assistance.

    Our Amazing Features

    delivery

    No missing deadline risk

    No matter how close the deadline is, you will find quick solutions for your urgent assignments.

    work

    100% Plagiarism-free content

    All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.

    time

    500+ subject matter experts

    Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.

    subject

    Covers all subjects

    We offer academic help services for a wide array of subjects.

    price

    Pocket-friendly rate

    We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.

    Getting started with MyEssayAssignmentHelp is FREE

    15,000+ happy customers and counting!

    Rated 4.7/5 based on
    1491 reviews
    ;