Request for Ti partner with spreadsheet skills

[DirectorAbbie]

I get the impression people would like it if I made a type test. I would do this by interrogating interviewing oodles of people whose types I am at least mostly sure of (I would double-check some with those I consider good at typing) and would use their answers to determine how their types (both socionics and enneagram) would be likely to respond to each question (I'll be asking for question suggestions in a different thread if I get support for this idea. I'll also probably swipe questions from other quizzes.). And like the last quiz I made, it will all be mathematically scaled for a likelihood of choosing rather than one choice per type. Unlike the last quiz, I won't be using that site because 15 questions just isn't enough for a thorough typology test.

So I thought it could be done on Google spreadsheets in a way that people could simply input their answers and have it calculate their likelihood of being each of the 16 and 9 types based on how people of those types responded. But I'm not familiar with that program, certainly not enough to set it up like that.
Also, I'm good at gathering and sorting data, but doing all the algorithmic stuff would be a time-consuming nuisance for me. So I thought someone more Ti-oriented could help.

Requirements to partner with me for this project:
-have as base, creative, or role function
-be skilled at google spreadsheets (or programming skills and a better idea of how to present the quiz)
-like math
-don't despise me
-have some free time
-have some interest in typology

[ouronis]

sounds fun. I am proficient at these activities.

[ClownsandEntropy]

I am happy to sub in for ouronis if that's ever needed

[Not A Communist Shill]

Finding the best questions (in terms of how good it is at assessing a person's type) and the best correlations for each answer would ideally require a sample larger than the number of forum members who are likely to participate, unless the questions are highly descriptive in line with the theory.

[DirectorAbbie]

a sample larger than the number of forum members who are likely to participate

I'll use off-forum people too. Maybe irl people. "Hey, you know nothing about this system, but I know exactly how you fit into it. So I printed out all this paperwork for you to do. Humor me?" @ouronis, if some of the people are like XII, will you be able to include them in the scoring for Ne-creative likelihood and nothing else?
If someone's type is mostly certain but there is some doubt, would it be better to leave them out, to include them, or to include them with a modifier that makes their answers affect the outcome less?
I'd also like a gender difference (since that's a dichotomy just like the others). Not so that it says "You're a girl!" at the end, but so that one can choose their gender at the beginning and it'll make females' answers have a bigger effect on their score than the males' (given they choose "female").

[ouronis]

I'll use off-forum people too. Maybe irl people. "Hey, you know nothing about this system, but I know exactly how you fit into it. So I printed out all this paperwork for you to do. Humor me?" @ouronis, if some of the people are like XII, will you be able to include them in the scoring for Ne-creative likelihood and nothing else?
If someone's type is mostly certain but there is some doubt, would it be better to leave them out, to include them, or to include them with a modifier that makes their answers affect the outcome less?
I'd also like a gender difference (since that's a dichotomy just like the others). Not so that it says "You're a girl!" at the end, but so that one can choose their gender at the beginning and it'll make females' answers have a bigger effect on their score than the males' (given they choose "female").

1. Function Granularity(XII/Creative Ne) - Likely. I'd have to know more about the system you plan on having put together. (yes)
2. Certainty - Maybe (yes)
3. M/F - Yes

Really, anything you think might change the outcome can be used as an input or modifier, as long as the final quiz is static.

[The Exception]

I could do this too if you need someone.

Why limit this to just Ti base/creative/role though? Any type can be proficient at using a spreadsheet.

[DirectorAbbie]

I could do this too if you need someone.

Why limit this to just Ti base/creative/role though? Any type can be proficient at using a spreadsheet.

Maybe we could all collaborate. Do you have skype, or is there a time we could meet on the chatbox?
It's not just spreadsheet proficiency I need. It's using equations and formulas to juggle and balance interconnecting numbers. And that seems to be a Ti sort of thing. I've got Te covered, so I don't need a partner with that.

[The Exception]

Maybe we could all collaborate. Do you have skype, or is there a time we could meet on the chatbox?
It's not just spreadsheet proficiency I need. It's using equations and formulas to juggle and balance interconnecting numbers. And that seems to be a Ti sort of thing. I've got Te covered, so I don't need a partner with that.

I have Skype and/or we could meet on the chatbox.

I have some experience with simple equations in spreadsheets. I can probably help with that if the equations aren't too complex.