Very Simple Excel Stats Problem


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, Статистика

Показать больше simple excel project grade, j2me simple excel, simple excel vba, descriptive statistics excel 2010, using excel for statistical analysis, microsoft excel statistics tutorial, basic statistics using excel, descriptive statistics excel 2017, descriptive statistics excel 2013, descriptive statistics excel 2016, descriptive statistics excel explanation, creating simple excel project, create simple excel php, excel utf8 problem, php excel utf problem, simple excel vba open external program, write simple excel program, excel ut8 problem, php excel output problem length, php simple excel reader

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

ID проекта: #19320311



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 отзывов(-а))

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


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 отзывов(-а))

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 отзывов(-а))

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 отзывов(-а))

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

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

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 отзывов(-а))

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 отзывов(-а))

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 отзывов(-а))

I will do it today

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

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 отзыв)