Posted: February 7th, 2015

Quantitative Techniques in Business

Paper, Order, or Assignment Requirements

Task 1 With the aid of suitable graphs discuss the following relationships:
i. Sales and Price
ii. Sales and Advert
iii. Sales and Experience
Your discussion should be supported with the relevant literature.

Task 2 With the aid of a correlation matrix; examine the nature of relationship between the variables. Support your discussion with the relevant literature.

Task 3 With the aid of a linear regression develop a model for the company using sales as the dependent variable. Your regression should be conducted at the 95% confidence level (or 5% level of significance) in Excel. Ensure your output is comprehensively synthesized.

I will also send you full details in Word file, you can check it.

MODULE TITLE: – Quantitative Techniques in Business (QTB)

———————————————————————————————————

Assessment Type

Assessment Type	Weight
Coursework – 3000 Words	40%
Examination – 2 Hours [Closed Book]	60%

Assignment Brief for November-February, 2014/15

The Table below shows the monthly sales of sunglasses by a firm over a period of 12months together with the details of average prices in each month, advertising expenditure per month; the mean daily hours of sunshine (MDH) in each month; number of households in the community and average years of experience of employees.

Months	Sales (£’000)	Price (£)	Advert Exp (£’000)	No. Households (Number)	Av. Sales Experience (years)	Mean Daily Hours (number)
January	75	6.8	2	515	10	2.4
February	90	6.5	5	542	18	4
March	148	6	6	576	18	5.2
April	183	3.5	7	617	11	6.8
May	242	3	22	683	14	8
June	263	2.9	25	707	18	8.4
July	278	2.6	28	500	17	10.4
August	318	2.1	30	742	14	11.5
September	256	3.1	22	747	12	9.6
October	200	3.6	18	770	13	6.1
November	140	4.2	10	515	18	3.4
December	80	5.2	2	542	14	2

Variable	Measurement
Sales	Total sales for the month (£’000)
Price	Average price of a sun glasses for the month (£)
Advertising Exp.	Average monthly expenditure incurred on advertising (£’000)
Households	The number of people in the community for the period month
Experience	Average number of years of sales experience (years)
Hours of Sunshine	Mean daily hours of sunshine (Hours)

Task	Activity
Task 1	With the aid of suitable graphs discuss the following relationships: Sales and Price Sales and Advert iii. Sales and Experience Your discussion should be supported with the relevant literature.
Task 2	With the aid of a correlation matrix; examine the nature of relationship between the variables. Support your discussion with the relevant literature.
Task 3	With the aid of a linear regression develop a model for the company using sales as the dependent variable. Your regression should be conducted at the 95% confidence level (or 5% level of significance). Ensure your output is comprehensively synthesized.
Task 4	Write your report – 3000words.

The structure of your report may be as follows

Task 3: Report Writing or Presentation

Write your report using the following contents:

Introduction [300 Words]

[the objective of the report; the key highlights to be captured; and so on]

Descriptive Statistics-Graphical Analysis [800 words]

2.1 Sales and Price

2.2 Sales and Advert

2.3 Sales and Experience

Correlation Analysis [800 words]

Discuss the nature of the relationship between the variables. This should be comprehensive and also supported with the relevant literature.

Regression Analysis [800 word]

Synthesise the regression output. Your discussion should take note of the resulting model; goodness-of-fit; the level of significance and the interpretation of coefficients. The discussion should be supported with the relevant literature.

Conclusion and recommendation (s): [300 Words]

Provide a suitable conclusion and recommendation that can used by the company or other similar companies

References

7.0 Appendix (ces)

The following Texts may be useful for this assignment

Curwin J. and Slater R. (2007) Quantitative Methods for Business Decisions, (5^thedn) Chapman& Hall

Wisniewski, M (2010) Quantitative Methods for Decision Makers, (5th edn) FT Prentice Hall

Lucey T (2002) Quantitative Techniques, Thomson Learning

Oakshott L (2006),Essential Quantitative Methods for Business, Management and Finance, (3^ndedn) Palgrave Macmillan

Swift, L, Piff, S. (2010) Quantitative Methods for Business, Management and Finance, (3^rd end) Palgrave

Field, A. (2009). Discovering statistics using SPSS. Sage publications.

Sekaran, U. (2006). Research methods for business: A skill building approach. John Wiley & Sons.

Note the following:

An assignment without citations (in-text referencing) will be an automatic fail;

An assignment that is suspected as copied or plagiarized will be taken through the necessary unfair practice procedures of the university and if found guilty, candidate will penalised

You are required to place serious emphasis on the synthesis of the statistical output. Support your discussion with relevant examples.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Quantitative Techniques in Business

Expert paper writers are just a few clicks away

Calculate the price of your order