skip to main content
US FlagAn official website of the United States government
dot gov icon
Official websites use .gov
A .gov website belongs to an official government organization in the United States.
https lock icon
Secure .gov websites use HTTPS
A lock ( lock ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

Explore Research Products in the PAR
It may take a few hours for recently added research products to appear in PAR search results.


Title: Introduction to Descriptive Research Administration Statistics using Excel
This session is a basic introduction to descriptive statistics for research administration professionals. No worries! Excel will be used throughout, nothing will be calculated by hand. Averages (means), medians, standard deviations, correlations and other basic statistical concepts will be explained using only research administration data as context. A sample research administration data set will be provided and Excel will be used to analyze the data. Some sample charts and best practices in creating these charts will also be shown. Again using Excel. This is the perfect session for anyone in research administration whose roles include analyzing data using descriptive statistics. Whether you are new to statistics or whether you can't remember a statistics class you might have taken at some point. Basic knowledge of Excel would be helpful for this session.  more » « less
Award ID(s):
2324388
PAR ID:
10566943
Author(s) / Creator(s):
Publisher / Repository:
University of Kentucky Libraries
Date Published:
Subject(s) / Keyword(s):
FOS: Computer and information sciences
Format(s):
Medium: X
Sponsoring Org:
National Science Foundation
More Like this
  1. (, University of Kentucky Libraries)
    This session will present on how to develop basic research administration dashboards using Tableau. A sample research administration dataset will be provided in Excel for anyone who would like to work along. Using that data set the presenter will show step by step how to import the data into Tableau and how to create basic worksheets and dashboards. Calculations and filters will be shown also. Attendees should download a trial version of Tableau the same week as the conference if they would like to work along the presenter. 
    more » « less
  2. ; (, University of Kentucky Libraries)
    In this session, we will start at the beginning and talk about what you need to think about in setting up research analytics capabilities for your organization. There are so many options for tools and other resources to get started, but what if you only have Excel? How do you get reporting off the ground when it hasn’t been done (or done consistently) at your workplace? We’ll talk about ways to get started, including who you need to talk with, what you need to consider, and how to move forward with basic reporting. Presented at the 2024 Research Analytics Summit in Albuquerque NM 
    more » « less
  3. (, University of Kentucky Libraries)
    General discussion session about how you at your institution are using or trying to deploy AI within research administration. This will be an informal discussion session. 
    more » « less
  4. (, University of Kentucky Libraries)
    Discover how to transform standard research award/proposal reports into dynamic visualizations of your research collaborations using Microsoft Power BI and custom visuals. This session guides you through creating interactive networks to visualize your research community. While we'll touch on network analysis, detailed statistical discussions are beyond the scope of this session. Participants are encouraged to bring a laptop and their data, although dummy data will be available. We'll cover data loading and transformation in Microsoft Power BI, employing custom visuals for network generation, and we will explore practical applications of research networks. Please download Microsoft Power BI Desktop beforehand if you plan to follow along, data can be provided or use your own! Presented at the 2024 Research Analytics Summit in Albuquerque, NM 
    more » « less
  5. (, University of Kentucky Libraries)
    The use of data and analytics in the field of research administration remains in explorations stages for many, if not most, higher education institutions. That is evidenced not only by the great demand and attendance seen for such sessions at NCURA’s Annual Meetings in 2022 and 2023, but also via prior research. This presentation will highlight the efforts implementing data-informed decision making based on research administration metrics, analytics, and dashboard examples. Emphasis will be placed on that you can’t manage what you can’t measure. The data analytics team at Emory supports all visions of our research administration leadership. Challenges, pain points, and lessons learned will be shared. Reasons for implementing collecting data and metrics will be shown. These include improving operational efficiencies, stakeholder satisfaction (e.g., faculty), as well as providing analytical insights to decision makers. The benefits of such initiatives will also be depicted with examples of successfully implemented metrics and analytics, including dashboard examples. 
    more » « less
  • Citation Formats
  • MLA
  • APA
  • Chicago
  • BibTeX
  • Save / Share this Record
  • Send to Email