Reference no: EM131849710 , Length: word count:2000

Assignment -

Firstly, need to prepare a questionnaire (survey) under the supervision of your lecturer with 10 questions. Need to include both qualitative and quantitative questions (at least one couple of independent and dependent variable MUST be included).

Secondly, students collect data from 20 respondents (sample size = 20) from the proposed population.

Thirdly, individual responses need to be transferred into an excel spread sheet in order to summarise variables and carryout required analyses.

Finally, survey results need to be reported according to the format given below.

Reporting Format

1. Title page Design a title page with an appropriate name for your business report, student name and student ID

2. Executive summary Here you need to summarise the whole report findings into a smaller paragraph (need to do at the end)

3. Table of contents Table of contents needs to be generated electronically in Microsoft words

4. Introduction Give a brief introduction about your population and aims and objectives of the report

5. Method of data collection Briefly describe about your questions, nature of your variables, who are your respondents, sampling strategy and how did you collect data. Include your data set in a form of table with this section or as an appendix.

6. Summary of the data set Give appropriate graphical and numerical summaries that describe your variables (Microsoft Excel can be used for this task). Also provide a brief discussion under each of your data summaries based on your judgments and compare your results with similar studies if possible.

7. Descriptive data analysis Select three numerical variables from your data set and prepare the summary of descriptive statistics using Microsoft Excel. Provide a brief discussion on Mean, Variance and Standard deviation and provide a brief discussion under each of your variables based on your judgments. Further, compare your findings with any similar studies if possible.

8. Simple linear regression analysis

• Select any two numerical variables (one must be dependent and the other variable must be independent)
• Develop a scatter diagram and discuss about the casual relationship between those two variables by observing the overall trend of your plots of coordinates.
• Estimate the functional relationship (simple linear regression) between the same variables (You MUST provide the method of calculations). Provide a brief discussion on your findings.
• Predict the dependent variable for any given value of your independent variable that is NOT available in your data set.

9. Conclusion and recommendations - Provide a brief overview of your collective findings and previous discussions in the report. Finally, provide several recommendations by connecting to your aims, objectives and overall findings.

10. List of references Minimum five references are required for this assignment task.

Word/Page Count: 2000.

Formatting & Referencing: Harvard.