Find Jobs
Hire Freelancers

Very Simple Excel Stats Problem

$10-30 USD

Completed
Posted almost 5 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 19320311

About the project

10 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in the resize scale will be decimals, but we can create a function to transform the scales. Please send me a message and I can start working on it inmediately.
$12 USD in 1 day
5.0 (10 reviews)
3.2
3.2
10 freelancers are bidding on average $24 USD for this job
User Avatar
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 in 1 day
4.9 (282 reviews)
7.2
7.2
User Avatar
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 till you satisfy if you want me. Contact me please. Thank you. Yang L.
$50 USD in 1 day
4.8 (51 reviews)
5.5
5.5
User Avatar
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 analysis and calculations.
$25 USD in 1 day
4.7 (48 reviews)
5.4
5.4
User Avatar
hi, I can help you pass this I have skills in Excel, statistics, SPSS, Stata, R Programming, data mining
$30 USD in 1 day
4.8 (15 reviews)
4.5
4.5
User Avatar
hay how are you... yes im thinking uts simple and I can help you with. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} • Translating ...........................................{English, Turkish, Farsi} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
$15 USD in 0 day
5.0 (16 reviews)
3.7
3.7
User Avatar
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 affordable price on time. We are waiting for good news from you My Best regards
$25 USD in 0 day
5.0 (4 reviews)
2.0
2.0
User Avatar
I will do it today
$14 USD in 1 day
5.0 (2 reviews)
1.5
1.5

About the client

Flag of UNITED STATES
Saratoga Springs, United States
5.0
86
Payment method verified
Member since Jul 18, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.