Modeling a skewed categorical (ordinal) variable

Hi Statalist,

The response scale of my dependent variable is structured as "Not at all" "To a small extent" "To a moderate extent" and "To a great extent." The survey question asks "Have your organization used social media for the following purposes?" 1) Newsletter, 2) Important announcements, 3) Customer service, 4) Events, 5) General community engagement, and 6) Recruitment.
My current strategy is to build a composite measure of social media use (eg., egen rowmean) where "Not at all" translates to 1, "Moderate extent" to 2, ..., and run it as an OLS model.
But the distribution is highly positively skewed where more than half responded to "Not at all" for most categories. I wonder if I should employ a different strategy (eg., multinomial logit, logit, count models).

My question is...
1. Is it OK to construct a composite score scale and run an OLS?
2. Is there a way I can model it as a composite measure rather than modeling the 6 subdimensions separately?
3. Any other suggestions I would highly appreciate.

Here is an example of my data. Thanks.

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str20(sm_newsletter sm_annoucements sm_customer sm_events sm_engagement sm_recruit)
"Not at all"           "To a great extent"    "To a great extent"    "To a great extent"    "To a moderate extent" "To a small extent"   
"Not at all"           "To a small extent"    "Not at all"           "To a small extent"    "Not at all"           "To a small extent"   
"To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"   
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a moderate extent" "To a small extent"    "To a great extent"    "To a moderate extent" "To a small extent"   
"Not at all"           "To a great extent"    "To a moderate extent" "To a great extent"    "To a moderate extent" "To a great extent"   
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"To a great extent"    "To a great extent"    "To a great extent"    "NA"                   "NA"                   "NA"                  
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"   
"To a moderate extent" "To a great extent"    "To a moderate extent" "To a moderate extent" "To a moderate extent" "Not at all"          
"To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"   
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"Not at all"           "To a moderate extent" "To a small extent"    "To a moderate extent" "To a moderate extent" "Not at all"          
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"To a small extent"    "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent"
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a moderate extent" "To a great extent"    "To a moderate extent" "To a great extent"    "To a moderate extent" "Not at all"          
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"To a moderate extent" "To a great extent"    "To a great extent"    "To a moderate extent" "To a moderate extent" "To a small extent"   
"To a small extent"    "To a small extent"    "To a small extent"    "To a small extent"    "To a small extent"    "To a small extent"   
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a great extent"    "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a moderate extent" "To a moderate extent" "To a moderate extent" "NA"                   "To a moderate extent" "To a small extent"   
"Not at all"           "Not at all"           "To a great extent"    "To a great extent"    "Not at all"           "To a small extent"   
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a great extent"    "Not at all"           "To a great extent"    "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a great extent"    "To a great extent"    "To a moderate extent" "To a great extent"    "To a great extent"    "To a moderate extent"
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a great extent"    "To a great extent"    "To a moderate extent" "To a moderate extent" "To a great extent"   
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"   
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "To a small extent"    "To a small extent"    "To a small extent"   
"To a great extent"    "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a moderate extent" "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a small extent"    "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a small extent"    "To a small extent"    "To a small extent"    "Not at all"           "Not at all"          
"To a small extent"    "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a small extent"   
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent"
"Not at all"           "To a small extent"    "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "To a small extent"    "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a small extent"    "Not at all"           "To a small extent"    "To a small extent"    "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a great extent"    "To a small extent"   
"Not at all"           "Not at all"           "To a small extent"    "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"To a small extent"    "To a small extent"    "To a moderate extent" "To a small extent"    "To a moderate extent" "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "To a small extent"    "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "To a small extent"    "Not at all"          
"To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent" "To a moderate extent"
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a small extent"    "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a small extent"    "To a small extent"    "Not at all"           "Not at all"           "Not at all"          
"NA"                   "NA"                   "NA"                   "NA"                   "NA"                   "NA"                  
"Not at all"           "Not at all"           "Not at all"           "To a moderate extent" "To a moderate extent" "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a moderate extent" "Not at all"           "Not at all"           "To a small extent"    "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "NA"                   "Not at all"          
"Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"           "Not at all"          
"Not at all"           "To a great extent"    "To a small extent"    "Not at all"           "Not at all"           "Not at all"          
end

Share on FacebookPlus on Google+