Create Research Presentation with Data processed through SPSS, Excell and Powerpoint.
Budget: £250 – £750 GBP
Create Research Presentation
with Data processed through SPSS, Excell and Powerpoint.
1. Background
• 2,000 records will be made available generated from an online survey.
• The data relates to 4 different video adverts. Each advert will have been seen by 500 individuals.
• 80% of the data collected are standard questions consistent with a separate small Excel Benchmark Table.
• The Benchmark Table contains the performance of another 14 adverts that went through the same process as these 4 adverts.
• The requirement is to compare the results of each advert with The Benchmark Table, create indices for each performance metric and display the results in a standardised Powerpoint Table.
• The 2000 data set also includes c5 questions that need to be cross-tabulated and reported on.
2. Steps
1. Within SPSS create weighted profiles for analysis
(e.g. Male, Female, Supporter Type)
2. Extract data from SPSS into Excel
3. Compare results for each advert against The Benchmark Table
4. Create indices for each performance metric
5. Cross tabulate additional 5 questions by agreed profiles
6. Put everything into Powerpoint format is precise position
3. Timing
1. Data available for analysis : Midday Monday 20th September :
2. Finished report : Thursday 24th September – midday UK time
4. Example of Dashboard
Notes from Head of Analysis and Operations
1. Typically we use the “Custom Tables” dialog in SPSS to create cross tabulations for the data. The method that the cross-tabulations are created are up to the worker. However, it is important that the cross tabulations are provided in an excel format so that the work can be checked.
2. Please ensure that percentages obtained for cross-tabulations are calculated via the column percent not the row percent. For example, we want the proportion of males which select X option, not the proportion of X option that are male. This is important and will affect the whole analysis so please discuss with the MD or the Head of Analysis and Operations if you do not understand this point.
3. You will be given brand colours for the charts and some general guidelines about branding. Please ensure that you follow these guidelines.
with Data processed through SPSS, Excell and Powerpoint.
1. Background
• 2,000 records will be made available generated from an online survey.
• The data relates to 4 different video adverts. Each advert will have been seen by 500 individuals.
• 80% of the data collected are standard questions consistent with a separate small Excel Benchmark Table.
• The Benchmark Table contains the performance of another 14 adverts that went through the same process as these 4 adverts.
• The requirement is to compare the results of each advert with The Benchmark Table, create indices for each performance metric and display the results in a standardised Powerpoint Table.
• The 2000 data set also includes c5 questions that need to be cross-tabulated and reported on.
2. Steps
1. Within SPSS create weighted profiles for analysis
(e.g. Male, Female, Supporter Type)
2. Extract data from SPSS into Excel
3. Compare results for each advert against The Benchmark Table
4. Create indices for each performance metric
5. Cross tabulate additional 5 questions by agreed profiles
6. Put everything into Powerpoint format is precise position
3. Timing
1. Data available for analysis : Midday Monday 20th September :
2. Finished report : Thursday 24th September – midday UK time
4. Example of Dashboard
Notes from Head of Analysis and Operations
1. Typically we use the “Custom Tables” dialog in SPSS to create cross tabulations for the data. The method that the cross-tabulations are created are up to the worker. However, it is important that the cross tabulations are provided in an excel format so that the work can be checked.
2. Please ensure that percentages obtained for cross-tabulations are calculated via the column percent not the row percent. For example, we want the proportion of males which select X option, not the proportion of X option that are male. This is important and will affect the whole analysis so please discuss with the MD or the Head of Analysis and Operations if you do not understand this point.
3. You will be given brand colours for the charts and some general guidelines about branding. Please ensure that you follow these guidelines.