An analyst is interested to understand the factors impacting the sales from the export of manufacturing organizations
Question:
An analyst is interested to understand the factors impacting the sales from the export of manufacturing organizations in geography. Based on his research he got indications that sales from exports may be positively impacted by % international ownership in the company and % foreign purchases. He collected data for 100 manufacturing organizations as given in the excel file. Answer the following questions based on the above and the given data. You are free to use any software to answer this question. Take only important part of the outputs in answer sheet to justify your description. No need to copy the input data or complete statistical output in answer sheet. Take your judgment call how detailed you like to explain in above questions based on the marks.
- Can sales from exports be predicted using the % international ownership, and % foreign purchase? The researcher also believes that the size of the organization in terms of employee strength may have variations in sales from exports, and therefore would like to control for it? Show your detailed work in your answer sheet and discuss the results from statistical point of view. (10)
- The analyst would like to develop a confidence interval of 96% for a difference in population means of ‘sales from exports’ of organizations with low versus high % foreign purchase. The organizations with % foreign purchase ‘low. Conduct the analysis, and describe in your answer sheet. (assuming equal variance of the two populations). (10)
- The analyst would like to conduct a two independent populations T test for zero difference in population means (assuming equal variance of the two populations) between low versus high % foreign purchase organizations. The organizations with % foreign purchase ‘(10)
- Explain your understanding of the relationship among the correlation between “% foreign purchase, sales from exports”, “beta coefficient of % foreign purchase from part (a)”, and “statistical result in part (b, and c)”. (10)
Compare and contrast if the findings in part a) are consistent for small versus large-size organizations at alpha 5% and at alpha 1%. Assume the organization with employee strength ‘
Management Accounting
ISBN: 9780730369387
4th Edition
Authors: Leslie G. Eldenburg, Albie Brooks, Judy Oliver, Gillian Vesty, Rodney Dormer, Vijaya Murthy, Nick Pawsey