INVESTIGATION 2 Mr Wilkinson's business consultant collected the total market value data of 14 companies (in millions) and their number of stock exchange transactions on a particular day. The business consultant wants to write a report about the relationship between the market value of a company and its number of transactions per day. Company 7 9 Market value imoni No of Transaction 02 -3 -2 15 8.5 51 62 64 25 59 - 4.6 4.5 94 249 229 147 157 316 15 218 189 204 299 21 245 330 Task 3 (Maximum 3 Marks) Learning Outcome(s) LO2 LOS LO6 Plot a scatter graph for the data provided above and describe the correlation between the market value of a company and its number of transactions taking place per day. Include your conclusion in your report Task 4 (Maximum 3 Marks) Mr Wilkinson is aiming to acquire a company with a market value of 9.1million. Your task is to predict the number of transactions (per day) for this company. You are expected to write in your report your prediction and its reliability Learning Outcome(s) LO3 LO5 LO6 Learning outcomes: Knowledge and Understanding LO2: Evaluate the strengths and weaknesses of alternative models, and consequently, of any conclusions drawn. Subject Specific Skills LO3: Identify, simplify and abstract the underlying mathematical structure of a business situation allowing a business-related problem to be modelled. LO4: Solve a range of business-related problems either deterministically or probabilistically as appropriate. LO5: Choose and apply appropriate techniques in algebra and calculus in finding a solution to a problem. Key and Employability Skills LO6: Use a range of IT packages, including calculators, spreadsheets, word processors and skills in the analysis and solution of business problems. INVESTIGATION 2 Mr Wilkinson's business consultant collected the total market value data of 14 companies (in millions) and their number of stock exchange transactions on a particular day. The business consultant wants to write a report about the relationship between the market value of a company and its number of transactions per day. Company 7 9 Market value imoni No of Transaction 02 -3 -2 15 8.5 51 62 64 25 59 - 4.6 4.5 94 249 229 147 157 316 15 218 189 204 299 21 245 330 Task 3 (Maximum 3 Marks) Learning Outcome(s) LO2 LOS LO6 Plot a scatter graph for the data provided above and describe the correlation between the market value of a company and its number of transactions taking place per day. Include your conclusion in your report Task 4 (Maximum 3 Marks) Mr Wilkinson is aiming to acquire a company with a market value of 9.1million. Your task is to predict the number of transactions (per day) for this company. You are expected to write in your report your prediction and its reliability Learning Outcome(s) LO3 LO5 LO6 Learning outcomes: Knowledge and Understanding LO2: Evaluate the strengths and weaknesses of alternative models, and consequently, of any conclusions drawn. Subject Specific Skills LO3: Identify, simplify and abstract the underlying mathematical structure of a business situation allowing a business-related problem to be modelled. LO4: Solve a range of business-related problems either deterministically or probabilistically as appropriate. LO5: Choose and apply appropriate techniques in algebra and calculus in finding a solution to a problem. Key and Employability Skills LO6: Use a range of IT packages, including calculators, spreadsheets, word processors and skills in the analysis and solution of business problems