# Very Simple Excel Stats Problem

Hello.

I have a very simple spreadsheet with four questions and roughly 25 respondents. Unfortunately, the first question is on a 1-5 scale and all others are an a 1-4 scale. I would like the scores for the first scale to be normalized (I think that is the right term) with all other scales. In other words, if the average for questions 2-4 is 3.5, then I would like to know what the equivalent value for question 1 would be if the result was, say, 3.2, but it is on a 1-5 scale. When I run the STANDARDIZE function, the number I get for question one doesn't make sense to me. It comes out to 1.6, but there isn't a simple question with a mean of 1.6. So, not only do I not know how to interpret that result, I don't know how to present the mean for question 1 in a way that is comparable to the means for the other questions. I'm guessing I'm using the wrong function.

For someone who knows statistics and Excel, this is an extremely quick way to make a few dollars. Please make reasonably low bids because I understand how simple a task this is for the right person. I would like the score and a brief explanation of what I did wrong and what you did correctly.

There where three small groups on dates March 15, March 19, and March 16. You will see scores for those dates in the spreadsheet.

Thank you.

Квалификация: Excel, Статистика

О работодателе:
( 86 отзыв(-а, -ов) ) Saratoga Springs, United States

ID проекта: #19320311

## Поручен:

maguirrer

Hello, I can help you with this project, I didnt understand the meaning of Sheet1, and I guess the correct scale will be: 1/5 : 1, 2, 3, 4, 5 will "scale" to the 1/4 and 1/4 : 0.8, 1.6, 2.4, 3,2, 4. I dont know if Больше

\$12 USD за 1 день
(10 отзывов(-а))
3.2

## 10 фрилансеров(-а) в среднем готовы выполнить эту работу за \$24

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

\$30 USD за 1 день
(282 отзывов(-а))
7.2
lightingdavid

Hello. I have good skills in "Excel, Statistics". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best Больше

\$50 USD за 1 день
(51 отзывов(-а))
5.5
daniyal3214

I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perfor various types of statistical a Больше

\$25 USD за 1 день
(48 отзывов(-а))
5.4
doctorkendrick20

hi, I can help you pass this I have skills in Excel, statistics, SPSS, Stata, R Programming, data mining

\$30 USD за 1 день
(15 отзывов(-а))
4.5
shahinrahimi

hay how are you... yes im thinking uts simple and I can help you with. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{J Больше

\$15 USD за 0 дней(-я)
(16 отзывов(-а))
3.7
arvindronin

Hi, I’m a data analyst and have been working with excel for over 15 years. I specialise in report automation & complex formula building. I can help you with your requirements regarding normalisation of the data. I’m Больше

\$25 USD за 1 день
(5 отзывов(-а))
3.0
mohamedaithmida

Hello sir ! We are a group of expert, each with a master's degree in economics and statistics , we have a good experience and brilliant skills in statistics using excel, we promise you for a quality work. at an Больше

\$25 USD за 0 дней(-я)
(4 отзывов(-а))
2.0
mehranica

I will do it today

\$14 USD за 1 день
(2 отзывов(-а))
1.5
frlncrsZviDAyqG

Hi In the example sheet I calculate that the first average of 4.4 for 26 March question 1 for a 1-5 rating would be "normalized" with the common base 1-4 values of the other questions to a value of 3.5 by a modific Больше

\$10 USD за 0 дней(-я)
(1 отзыв)
1.1