How to import sample data using marked points into Spotfire Statistica Data Entry

How to import sample data using marked points into Spotfire Statistica Data Entry

book

Article ID: KB0138559

calendar_today

Updated On:

Products Versions
Spotfire Statistica - All Servers 14.3 14.4

Description

Using a spreadsheet with marked points, samples can be imported into Statistica Data Entry.  This articles provides an example of how to upload data to a data entry setup with pieces of variable size.

Environment

OS:  Windows

Resolution

Data Entry Template

 

1.  As an example, create a  data entry setup with two piece labels and one Individual and Moving Range (IMR) characteristic, like the following:

image.png

image.png

 

2.  Download the data entry template for the data entry setup by selecting "Import Data" and then selecting "Download Template":

  image.png

 

image.png

 

The template spreadsheet contains the following:

image.png

 

3.  Add the sample data to the spreadsheet and mark the row which corresponds to the beginning of the sample. 

Note these samples have three pieces each:

image.png


Using marked points, samples can have variable sizes.  In the spreadsheet below, one sample has four pieces but the rest have only three:


image.png


 

Note:  To mark the row that begins the sample, right-click on the row and select "Marked Points":

image.png

 

 

Import to Data Entry

 

1.  Select the Data Entry setup

2.  Select the "Choose File" button

3.  Click "Upload"

4.  Select "Auto Match" 

image.png

 

5.  Select options, if applicable, otherwise leave as default and click "Import Data":

image.png

 

6.  Click "OK" on the notification and view the results at the bottom of the page:

image.png

 

image.png

 

Note: Additionally, an email notification can be configured to send the import results (see page 67 of the Spotfire Statistica® Data Entry Administration guide https://docs.tibco.com/pub/stat-all-servers/14.4.0/doc/pdf/SPOT_stat-all-servers_14.4.0_admin_data_entry.pdf?id=3).



Issue/Introduction

How to import sample data using marked points into Spotfire Statistica Data Entry.

Additional Information

For more information about importing samples into data entry, please see pages 64–67 of https://docs.tibco.com/pub/stat-all-servers/14.4.0/doc/pdf/SPOT_stat-all-servers_14.4.0_admin_data_entry.pdf?id=3

 

 

Powered by Wolken Software