# 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]

Beceriler: Google Sheets, Excel, Veri İşleme

İşveren Hakkında:
( 5 değerlendirme ) St Leonards, Australia

Proje NO: #27919847

## Seçilen:

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.

%selectedBids___i_period_sub_7% gün içinde 70%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
1.2

## Bu iş için 16 freelancer ortalamada \$68 teklif veriyor

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 Daha Fazla

\$150 AUD in 3 gün içinde
(392 Değerlendirme)
8.1
(178 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(79 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(46 Değerlendirme)
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 gün içinde
(25 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(12 Değerlendirme)
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 gün içinde
(3 Değerlendirme)
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 Daha Fazla

\$60 AUD in 3 gün içinde
(2 Değerlendirme)
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 Daha Fazla

\$60 AUD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$50 AUD in 7 gün içinde
(1 Yorum)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$60 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$55 AUD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$60 AUD in 7 gün içinde
(2 Değerlendirme)
0.1