I gang

Google Sheets: Producing Norms for Respective Google Form Responses

As a psychology practice, we often get clients to fill in questionnaire data which is later converted and scored so our clinicians can read this data. At the moment, we have a system so that the Google Form answers are converted to Google Sheets and we have entered some formulas for them to be scored. However, we want to add formulas so that we can now calculate the average norm data and compare it to our clients.

At the moment we are using a formula like so - =IF(OR(ISBLANK(#REF!)), "",if(AU6>6.06,"above norm","normal"))

Basically, we are using an average data point of a norm to figure out whether the client’s score is above or below the norm of 6.06. However, our issue is that this norm is actually just averaged and we want to figure out the norm for specific age brackets and genders.

We need this done for a quite a few separate questionnaires x5), but we can always do it ourselves too if we just get the basic outline of the formula. If it helps, for one of the questionnaires, we can also provide some SPSS syntax (see attached) that is used in someone else’s automatic norm spreadsheet. The two questionnaires we need the norms for is the Spence Children's Anxiety Scale (x2 types of questionnaires: child and parent) and Revised Children's Anxiety Scale (x3 types of questionnaires: child, parent and preschool). You can find these norms online if you want some more information.

Project objectives

- We would like the norms to automatically populate when the Google Forms response comes through (scoring has already been done)

- We would like these norms for 5 different scales (RCADS – Parent, RCADS – Child, Spence Preschool, Spence Parent, Spence Child)

- We would like to be informed about how and which formula was used to complete this task so we have some basic knowledge if we need to edit these in the future

If you believe you can complete this task, we ca later provide you with the document link and norms (you can also find these norms very easily online by looking up RCADS Scale or Spence Scale).

DETAILED EXAMPLE OF WHAT WE NEED

For the two RCADS questionnaires, you can find them here along with instructions of what the norm should be according to the table (see scoring sheet at the bottom):

[login to view URL]

[login to view URL]

This is the referred to normative data: [login to view URL]

For the Spence scales, you can find the sheet with instructions and examples here (see scoring tab at the bottom):

[login to view URL]

You can find the normative data here:

[login to view URL]

Evner: Google Sheets, Excel, Databehandling

Se mere: response validation google forms, how to create a google form with spreadsheet, google forms, google forms examples, google forms multiple response validation, google form to google sheet, google form example, advanced google forms, direction html form script google, joomla form link google map api, post form data google docs, php form data google docs, form send google maps, search form frontpage google, add registration form site google, form php google maps api, learning excel adding values sheets producing results sheet, mail form php google smtp, pass form data google searches, saving form php google spreadsheets api

Om arbejdsgiveren:
( 5 bedømmelser ) St Leonards, Australia

Projekt ID: #27919847

Tildelt til:

sureshkatla

Hi, I can do this project. I have extensive knowledge with google sheets. Ping me discuss further. Edit: I just found a easy way doing it. So reduced my bid amount as my efforts are reduced.

$70 AUD in 2 dage
(1 bedømmelse)
1.2

16 freelancere byder i gennemsnit $68 timen for dette job

schoudhary1553

Hi, Greetings! ✅checked your project details: Google Sheets: Producing Norms for Respective Google Form Responses ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the e Flere

$150 AUD in 3 dage
(392 bedømmelser)
8.1
(176 bedømmelser)
6.6
royalcalif

Hi Mr. Employer, Basically the Google sheet is running by Javascript. So we have some knowledge in JavaScript. I have a lot of experience in Google sheets and I can do this project in an effective manner with 100% accu Flere

$50 AUD på 1 dag
(79 bedømmelser)
5.7
merinsinha

GOOGLE SHEET EXPERT-----I CAN START RIGHT AWAY PLEASE AWARD ME SIR----- Hello sir, checked description and attachment. I can do this as your requirements by maintaining 100% accuracy of your data absolutely as you wan Flere

$70 AUD på 1 dag
(46 bedømmelser)
4.4
JohnRikz

Excel and google sheets expert Let's discuss your project and will complete it as needed. I will prepare a presentation of the formula used for you as a reference. John

$50 AUD in 7 dage
(25 bedømmelser)
4.3
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per Flere

$100 AUD på 1 dag
(12 bedømmelser)
3.0
jasminetabassum6

Hi, i would like to work with you. please send me more detail. I will provide you quality work according to your instructions. If you interested. Please contact me.I am waiting for your message.

$50 AUD in 2 dage
(3 bedømmelser)
1.0
sajedali784

Dear Researcher I am experienced academic writer and expert in SPSS and AMOS for data analysis (Regression, ANOVA, Correlation, t-test, Chi Square test, Block Plot, SEM, CFA and EFA etc.). I always provide results al Flere

$60 AUD in 3 dage
(2 bedømmelser)
0.5
sohidulislam571

Hi There! Your job post has caught my attention because I'm a Data Entry expert and I’m considering your job for me as I have these capabilities. I always respect quality, punctuality, and commitment to my job. I can a Flere

$60 AUD in 3 dage
(0 bedømmelser)
0.0
Nirmal5828

Hi , I have been go through the attached files and scan both the documents,I have been working as a ETL developer for 9+ years,sound knowledge of using excle formulas and handling google sheets. Expert in data analysin Flere

$50 AUD in 7 dage
(1 bedømmelse)
0.0
moharsingh3051

Hi, I have read your job description carefully and I assure you that l am a perfect fit for your project. I will be able to provide you best results. Message me so that we can discuss more about your project.

$50 AUD in 6 dage
(0 bedømmelser)
0.0
RosniDahlia

I am very much confident in our succession together as I am punctual and creative. I want to use the skills that I have to foster and enhance your projects I will be involved with. I am a hard worker and self-motivated Flere

$60 AUD in 7 dage
(0 bedømmelser)
0.0
kunalsinghsekh9

I will give my best on this work so that I can impress you for further more work. I need money for some personal work and its an emergency. I am a freshy in here and need this job. Here is my sample blog: file:///C:/Us Flere

$55 AUD in 3 dage
(0 bedømmelser)
0.0
MumtazWebData

I saw your job “ online data entry ” and all job Description. Thanks for the job invite. I have 4 years experience on Data Entry, Excel Sheet, Data Processing, Data Scraping, Data Mining, Copy Typing, Copy Writing, Web Flere

$60 AUD in 7 dage
(2 bedømmelser)
0.1
aniketad900

Iam a data entry specialist, i can do all types of data entry works and have experience in excel. There will be no excuses while doing the work. Will deliver your project done within the days i have mentioned.

$90 AUD in 6 dage
(0 bedømmelser)
0.0