** ** **Important Notice: **

As this is an individual assessment item, students **MUST** work on their own and present their individual assignment submission. If found to have cheated, your submission would receive a mark of zero for this assessment item. Note: University uses text-matching tools to detect academic cheating, collusion and plagiarism.

Don't use plagiarized sources. Get Your Custom Essay on

1305AFE Business Data Analysis

Get a plagiarism free paperJust from $13/Page

__Instructions:__

*Please do read all of these instructions carefully.*

- Answer all questions
- Worth 40 marks (40%)
- Release date and time: Wednesday, 3 Feb 2021, 3.00pm
**Due date and time: Friday, 5 Feb 2021, 3.00pm**- Display all your working for questions where you need to do calculation. This is not an Excel computing assignment. You need to display your manual calculation working.
- Your final submission
**must**be presented and submitted in a Word document in .doc or .docx format.*No pdfs or Excel files or other type of document format will be accepted!* - Students
**must**complete the Academic Integrity digital cover sheet of this assessment item, available under*Assessment*tab in the Learning@Griffith course site. - Students
**must**submit the completed work through the submission link provided under*Assessment*tab in the Learning@Griffith course site. - You are required to keep a hard copy and an electronic copy of your submitted assignment to re-submit, in case the original submission is lost for some reason.

* *

* *

* *

*Problem 1 – Efficiency analysis of workflow system*** (8 marks)**

John is the Chief Financial Officer of a very large software company that employs more than 5,000 programmers. He is committed to increase funding to the development of the company’s new workflow system if at least 20% of his programmers agree that the system significantly enhances their work efficiency. 700 programmers were randomly selected and surveyed for this analysis. 175 programmers stated that they find the workflow system is useful and boost their work efficiency. Estimate with 99% confidence the proportion of all of the company’s programmers who find the new workflow system useful for their work efficiency.

- Suppose you were a researcher working for the data analytic department of the company. Which formula would you select in solving the problem? Provide a brief reason on your selection. 1 mark

- Obtain the lower confidence limit and the upper confidence limit of the 99% confidence interval estimate of the proportion of all the company’s programmers who find the new workflow system useful for their work efficiency. Display working. 3 marks

- Present an interpretation of the lower confidence limit and the upper confidence limit obtained in part b) in the context of the problem. 5 marks

- Based on the interval estimation you just conducted, present brief statements of two or three sentences for John, the Chief Financial Officer. Should he allocate more funding for the development of the company’s new workflow system? Yes or no? Why? 5 marks

- What would happen to the width of the interval when a lower sample size is used? Assume all of the other variables to do the calculation of confidence interval held constant. 1 mark

* *

* *

* *

*Problem 2 – Used car price evaluation *** (10 marks) **

It is estimated that around 13% of the residents of Jakarta use cars to commute. Despite the current Covid-19 pandemic, a large car dealership in the city reported that the demand for used mid-size passenger sedans in the city has become stronger. The dealership further claimed that the average selling price for used mid-size passenger sedans is now more than $9,500. In verifying this, a random sample of 120 used mid-size passenger sedans is selected. The average price calculated from the sample is $9,600. Assume that the population standard deviation of the price is $1,200.

- Suppose you were a junior business analyst working for the dealership. Assist the dealership in performing a hypothesis test at a 10% level of significance to check whether the dealership’s claim is supported. Display the six steps process (involving drawing the rejection region/s and determining the critical value/s for the decision rule) in performing the test. 6 marks

- Specify the decision rule to use in the p-value method hypothesis testing. Calculate the p-value of the test above. Display working. 2 marks

- Which one of these two types of error (i.e Type I or Type II) you could make with the conclusion you made in part a)? Briefly explain your selection. 1 mark

- What is the required condition for ensuring that the sampling distribution of the sample mean is approximately normally distributed? Check if the condition is satisfied in the hypothesis testing that you just completed. 1 mark

*Problem 3 – Consumer behaviour theory*** (16 marks)**

*“Consumers are likely to purchase more of a good when the price of the good decreases, and vice versa.” *

As stated above, a marketing theory in the field of consumer behaviour believes that an indirect relation is likely to exist between the price and the number of units purchased for most of the goods and services. In examining this, you were commissioned as a student in the Business Data Analysis course to conduct a mock market research surveying a sample of potential customers in purchasing a hypothetical new product. You randomly selected 16 of your fellow students as the potential customers for the product. You questioned them on the number of units they were likely to purchase for a given price that you set. The data you collected from the mock survey are displayed below. You are tasked in performing the relevant inferential analyses on the relation between the two concerned variables by addressing the below set of questions.

Potential Customer | Set Price | |

Number of units | ||

purchased | ||

in $ |
||

Matt | 13 | 21 |

Kim | 15 | 15 |

Ken | 13.5 | 21 |

Tom | 15 | 13 |

Tim | 16.5 | 14 |

Anne | 13.5 | 22 |

Will | 14 | 19 |

Joe | 14.2 | 17 |

Jim | 16.5 | 13 |

Naomi | 17 | 13 |

Mike | 17.2 | 14 |

Megan | 18 | 15 |

Jennie | 20 | 17 |

Andy | 21 | 14 |

Bill | 19 | 17 |

Tony | 19.5 | 16 |

- Which of the two concerned variables is the dependent variable? Which one is the independent variable? Give an explanation of the rationale of the selection of the dependent and independent variables. (1 mark)

- The following sums have been computed:

Use this info to calculate S_{x}^{2}, S_{y}^{2} and S_{xy}. Display working.

(1.5 marks)

- Calculate the sample correlation coefficient. Display working. Then, provide an interpretation of the calculated correlation in terms of the relation between price and number of units purchased. (2 marks)

- Calculate the slope coefficient of the sample linear regression. Then, calculate the intercept coefficient of the sample linear regression. Display working. (1 mark)

- Write the estimated sample linear regression equation. (1 mark)

- Provide interpretations of the slope coefficient and the intercept coefficient of the sample linear regression in terms of the relation between price and number of units purchased.

(2.5 marks)

- Predict the number of units purchased if price is $25. Display working. Comment on the validity of this prediction. (2 marks)

- Calculate the coefficient of determination for the regression line. Provide an interpretation of the calculated coefficient of determination in terms of the relation between price and number of units purchased. (2 marks)

- Perform the relevant hypothesis test at the 5% level of significance to see if a negative relation exists between price and number of units purchased. Display working of the six-steps of the hypothesis test. The t test-statistic has been calculated. t calculated = -2.35.

(3 marks)

* *

* *

*Problem 4 – Time spent for meeting during Covid ***(6 marks)**** **

A newspaper report stated that the hours spent by office workers in attending meetings have increased substantially during Covid-19. A study is conducted to examine the amount of time that office workers spend in attending meetings per week during the pandemic. The amount of time that office workers spend in attending meetings per week during Covid is normally distributed with a mean of 9 hours and a standard deviation of 1.5 hours.

- What is the probability that one randomly selected office worker would spend more than 6 hours per week for meetings? Display working. 1 mark

- At most how much time per week (in hours) would be used by the 3% office workers who spend the shortest amount of time for meetings? Display working.

2 marks

- An analyst randomly selected five office workers. What is the probability that the mean amount of time per week spent for meetings for those five workers is less than 11 hours per week? Display working.

1.5 marks

- Further, the analyst randomly selected four other office workers. What is the probability that the average amount of time per week spent for meetings for those four workers is between 8 hours and 10.5 hours? Display working.

1.5 marks

Our Advantages

Plagiarism Free Papers

All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.

Free Revisions

All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.

Title-page

A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.

Bibliography

Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.

Originality & Security

At Homework Valley, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.

24/7 Customer Support

Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.

Try it now!

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We work around the clock to see best customer experience.

Pricing

Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.

Communication

Admission help & Client-Writer Contact

When you need to elaborate something further to your writer, we provide that button.

Deadlines

Paper Submission

We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.

Reviews

Customer Feedback

Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.