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.

Kĩ năng: Excel, Statistics

Về Bên Thuê:
( 86 nhận xét ) Saratoga Springs, United States

ID dự án: #19320311

Được trao cho:

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 Thêm

\$12 USD trong 1 ngày
(10 Đánh Giá)
3.2

10 freelancer đang chào giá trung bình \$24 cho công việc này

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 trong 1 ngày
(282 Nhận xét)
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 Thêm

\$50 USD trong 1 ngày
(51 Nhận xét)
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 Thêm

\$25 USD trong 1 ngày
(48 Nhận xét)
5.4
doctorkendrick20

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

\$30 USD trong 1 ngày
(15 Nhận xét)
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 Thêm

\$15 USD trong 0 ngày
(16 Nhận xét)
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 Thêm

\$25 USD trong 1 ngày
(5 Nhận xét)
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 Thêm

\$25 USD trong 0 ngày
(4 Nhận xét)
2.0
mehranica

I will do it today

\$14 USD trong 1 ngày
(2 Nhận xét)
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 Thêm

\$10 USD trong 0 ngày
(1 Nhận xét)
1.1