I'm doing some basic research on relationships between factors (resources, policy, socio-cultural).
Please find attached XLS with mock data (and thus mock graph/model) -- on "Basic Info" tab. Also, on the 2nd, 3rd, and 4th tab, I've included mock data/survey.
So, given that everything's "mock", please ignore whether or not the presented data makes sense.
Instead, I'd like to determine if a different graph (vs. the basic line graph) could be utilized. More specifically, depending on >> potential << relationship between the three factors, could there be a "drop-off" scenario (e.g., a curved model). That is, instead of just plotting the 20 data points sequencially, the graph would take on the shape of maybe a bell curve.
What do I mean by the last statement? So, depending on the data set, performance (either by itself OR based on all three curves combined) might steadily increase until a certain point. Then, however, it'll drop (following the principles of the "law of diminishing return"). [At this time, I'm not sure how to "combine" the data points across the three factors. Maybe you have some suggestions.]
Does anyone have a recommendation for achieving such "model" given the provided (sample/mock) data?
I'd welcome any ideas that would illustrate the data differently vs. just using the line graph.